Shaun Cassells at MyITForum.com

SMS 2003 and ConfigMgr 2007, PowerShell, Scripting, Finance, Fitness and Fun

News

Locations of visitors to this page

Query: HINV older than 15 days

SELECT dbo.v_R_System.Name0, dbo.v_GS_WORKSTATION_STATUS.LastHWScan

FROM dbo.v_GS_WORKSTATION_STATUS

INNER JOIN

dbo.v_R_System ON dbo.v_GS_WORKSTATION_STATUS.ResourceID = dbo.v_R_System.ResourceID

where datediff(day, dbo.v_GS_WORKSTATION_STATUS.LastHWScan, getdate()) > 15

 

Posted: Jan 20 2009, 08:32 AM by scassells | with no comments
Filed under: , , , ,

Comments

No Comments