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