Wednesday, September 22, 2010

Query to find machines with hardware inventory FUTURE scan Date

select a.Name0,b.LastHwscan from v_r_system a inner join v_GS_WORKSTATION_STATUS b on
a.resourceID=b.resourceid where b.LastHwscan >getdate()

Description: This query will help you to find machines which are sending back a future scan date to the SMS server. This normally happens when the clock on the workstation is changed by someone (may be accidentally), and then if it ran the scan, it would report the local scan date. To resolve this you may to manually initiate a delta hardware scan on the problematic machines.


Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home