select username ,cast(cast(logondate as format 'YYYY-MM-DD') as varchar(100)) ,cast(logontime as varchar(100)) ,ClientIpAddress ,ClientProgramName ,ClientSystemUserId ,event from dbc.logonoff where logdate >= date '2018-09-25' -- provide date and event not in ('Logon','Logoff') -- and username='<USERNAME>' --Remove comment & Provide Username for filter order by 1 desc, 2 desc;
|