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;