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