Enforcement states for the software updates department
select
sn.StateName as LastEnforcementState,
vrs.name0 as ComputerName,
a.AssignmentName as DeploymentName,
assc.StateTime ,
a.CollectionName
from v_CIAssignment a
join v_AssignmentState_Combined assc on a.AssignmentID=assc.AssignmentID
join v_StateNames sn on assc.StateType = sn.TopicType and sn.StateID=isnull(assc.StateID,0)
join v_R_System vrs on vrs.ResourceID=assc.ResourceID
where
a.AssignmentID='xxxxxxxx'
--or a.Assignment_UniqueID like '************'
order by LastEnforcementState
Query Results:-
