Locating Machines That Performed A Hardware Scan Within The Last Week

 

This SQL query will locate machines in your SMS inventory that have reported a hardware scan in the last week or 7 days.

 

Sql Query:

 

Select    

CS.Name0 'Machine Name',

WS.LastHwScan 'Inventory TimeStamp',

DateDiff(D, WS.LastHwScan,

GetDate()) 'Inventory Age In Days:)'

From WorkstationStatus_Data WS

Join System_Disc CS on WS.MachineId = CS.ItemKey

Where (DateDiff(D, WS.LastHwScan, GetDate()) >= 7)

 

Published Sunday, October 29, 2006 5:10 PM by dhite
Filed under:

Comments

No Comments