WQL Queries - Collection where computer hasn't inventoried in 60 days
Main Menu
>
Tools
>
WQL Queries
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.
Code
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()) )
Documentation
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 --------------------------------