WQL Queries - Collection where computer hasn't inventoried in 60 days
Collection where computer hasn't inventoried in 60 days
Create a collection of computers that hasn't inventoried in 60 days or hasn't sent a HW inventory.
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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Name not in (select SMS_R_System.Name from SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_WORKSTATION_STATUS.LastHardwareScan >= DateAdd(dd,-60,GetDate()) )
You might want a collection instead of report for several reasons. You might want to see who is falling behind since they will most likely receive many advertisments. Maybe you want to see which computers just having inventory issues. Granted some of your machines will remove from this collection as aged data is removed or their client flag is removed. Created by Matthew Hudson --------------------------------