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