Check Failed Logon Information in Teradata

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

Comments