отчёт по компьютерам в состоянии «Pending reboot» после установки обновлений

 SELECT DISTINCT dbo.v_R_System.Name0, dbo.v_Update_ComplianceStatus.LastEnforcementMessageID, dbo.v_FullCollectionMembership.CollectionID
FROM            dbo.v_R_System INNER JOIN
                         dbo.v_Update_ComplianceStatus ON dbo.v_R_System.ResourceID = dbo.v_Update_ComplianceStatus.ResourceID INNER JOIN
                         dbo.v_FullCollectionMembership ON dbo.v_R_System.ResourceID = dbo.v_FullCollectionMembership.ResourceID
WHERE        (dbo.v_Update_ComplianceStatus.LastEnforcementMessageID = 9) AND (dbo.v_FullCollectionMembership.CollectionID = N'FRA00020')

Leave a Reply