User History

Find the user history for a PC.

SELECT DISTINCT
 GS.Name0,
 CSH.TimeStamp,
 CSH.UserName0
FROM
 v_GS_COMPUTER_SYSTEM GS,
 v_HS_COMPUTER_SYSTEM CSH
WHERE
 GS.ResourceID = CSH.ResourceID
 AND CSH.UserName0 Is Not Null
 AND GS.Name0= ‘Computer Name Here’
ORDER BY
 CSH.TimeStamp

Hope you find this useful.

Leave a Reply

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