Report for listing all the devices a users has logged onto along with their last logon time

SELECT

DISTINCT Max(HCU.LastConsoleUse0),

HCU

.SystemConsoleUser0,

S

.Name0

FROM

dbo

.v_GS_SYSTEM S join dbo.v_HS_SYSTEM_CONSOLE_USER HCU on S.ResourceID = HCU.ResourceID

WHERE

HCU

.SystemConsoleUser0=‘Enhansoft\Garth’

group

by

S

.Name0,

HCU

.SystemConsoleUser0

Order

by

S

.Name0,

HCU

.SystemConsoleUser0

Leave a Reply

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