17.10 - Example: Generating a Report of All Restarts and Logon-Enabled Events in the past 11 Days - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Publication ID
B035-1103-171K
Language
English (United States)

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