Teradata Viewing Failed Logon Information

In Teradata, there is a way to view the reason that a username is not authenticating.  Teradata is good about collecting information at the time of authentication.  It can be verified, when an error like “Error: Logon failed!” occurs, if it is something like a bad password, or if the account is locked.

select
  cast(cast(logdate as format 'YYYY-MM-DD') as varchar(100))
  ,cast(logtime as varchar(100))
  ,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 '2016-12-01'
  and event not in ('Logon','Logoff')
  order by 1 desc, 2 desc

More columns can be added to the query with good information. To view all the information that can called from the “dbc.logonoff” view: “help view dbc.logonoff

Comments are closed.