Wednesday, 12 November 2014

Configuration Manager 2012: Query for Machines without Client and Show Last Machine Logon Time with Operating System

The title is a mouthful but this is a quick way to get a list of machines that may be potential clients. This query assumes that Active Directory system discovery is enabled with the default attributes.

select SMS_R_System.Name, SMS_R_System.LastLogonTimestamp, SMS_R_System.OperatingSystemNameandVersion from  SMS_R_System where SMS_R_System.Client = "0"