16.20 - Example: Generating a Report of All Restarts and Logon-Enabled Events in the past 11 Days - Teradata Vantage NewSQL Engine

Teradata Vantage™ SystemFE Macros

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
featnum
B035-1103-162K

The following statement generates a report of all restarts and logon-enabled events for the last 11 days:

Exec ListRestart_Logon_Events(date-10,date);

The resulting report follows:

EXECUTE ListRestart_Logon_Events (date-10,date);
 *** Query completed. 17 rows found. 5 columns returned.
13/05/29                  (Crashable/logon-enabled Events)                 09:42
                        Between 2013-05-19 and 2013-05-29
    Date            Time Message Text
-------- --------------- -------------------------------------------------------
13/05/21 00:55:17.162969 13/05/21 00:55:17 Logons are enabled
13/05/26 03:06:04.232870 13/05/26 03:06:04 Logons are enabled
         22:40:15.943210 13/05/26 22:40:15 Logons are enabled
13/05/27		 00:39:52.300814 13/05/27 00:39:52 Logons are enabled
         01:07:21.218686 13/05/27 01:07:21 Logons are enabled
         01:16:14.637825 13/05/27 01:16:14 Logons are enabled