The DBC.LogOnOffV view provides information about the success and duration of user sessions, in addition to LogonSource information. This view is helpful to investigate failed logon attempts.
This query returns a list of failed logon attempts that occurred in the last seven days:
SELECT LogDate,LogTime,UserName,Event
FROM DBC.LogOnOffV
WHERE Event NOT LIKE ('%Logo%') AND LogDate GT DATE - 7
ORDER BY LogDate, LogTime ;
Result:
LogDate LogTime UserName Event --------------------------------------------------------- 07/07/30 08:55:22 Non-existent User Auth Failed 07/10/21 08:59:53 BRM Bad Account
For more information on possible values for DBC.LogOnOffV.Event, see Teradata Vantage™ - Data Dictionary, B035-1092.