SCCM2012R2: Collection query for inactive clients

Create a collection using the following query and you will get all the workstations which are inactive:

SELECT
   SMS_R_SYSTEM.ResourceID,
   SMS_R_SYSTEM.ResourceType,
   SMS_R_SYSTEM.Name,
   SMS_R_SYSTEM.SMSUniqueIdentifier,
   SMS_R_SYSTEM.ResourceDomainORWorkgroup,
   SMS_R_SYSTEM.Client 
FROM
   SMS_R_System 
INNER JOIN
   SMS_G_System_CH_ClientSummary on SMS_G_System_CH_ClientSummary.ResourceId = SMS_R_System.ResourceId 
WHERE 
   SMS_G_System_CH_ClientSummary.ClientActiveStatus = 0

You can update this collection every day. Click on the “schedule” button to suit your needs.

 

Thanks for reading! You can follow me on Twitter @PrigentNico