SCCM Reports – No SCCM agent workstation client

select all SMS_R_System.Name0,SMS_R_System.Last_Logon_Timestamp0,SMS_R_System.Resource_Domain_OR_Workgr0,SMS_R_System.Client0,SMS_R_System.Operating_System_Name_and0 from vSMS_R_System AS SMS_R_System
WHERE (Client0 IS NULL) AND (Operating_System_Name_and0 NOT LIKE Nā€™%OS X%ā€™) AND (Operating_System_Name_and0 LIKE Nā€™%Microsoft Windows NT Workstation%ā€™)
ORDER by 2

Leave a Reply