How to find all PCs installed within the last week.

Use this query to find all PCs installed within the last week.

SELECT CS.Name0,
 CS.UserName0,
 OS.InstallDate0
FROM
 v_GS_COMPUTER_SYSTEM CS,
 v_GS_OPERATING_SYSTEM OS
WHERE
 CS.ResourceID = OS.ResourceID
 and datediff(DD,OS.InstallDate0,Getdate())< 7
ORDER BY
 CS.Name0

 

Leave a Reply

Your email address will not be published. Required fields are marked *