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;

UserName	LogonDate	LogonTime	ClientIpAddress	ClientProgramName	ClientSystemUserId	Event
OBI_ADMIN	2018-09-25	09:39:30.45	194.15.144.56	NQSSERVER	SIEBELSERVICE	User Locked
AXBO	2018-09-25	04:00:32.08	194.15.157.81	java.lang.Thread.run(Thread.java:745)	sonic	Forced Off
A00010	2018-09-25	07:55:16.14	172.21.8.202	WINDDI	A00010	Bad Password