Who was the last person to logon to each PC.

SELECT Distinct
CS.Name0 as ‘PC Name’,
isnull(CS.UserName0,HCS.UserName0) as ‘User Name’
FROM
v_GS_COMPUTER_SYSTEM CS,
v_HS_COMPUTER_SYSTEM HCS
WHERE
HCS.ResourceID = CS.ResourceID
AND HCS.UserName0 is not NULL
Order by

Leave a Reply

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