ListEvent
Returns a particular event code for the set period of time.
Syntax
where:
|
Syntax element … |
Specifies … |
|
Event |
the number of the event code for which you want to search. The format of event is an integer, as shown in Event Code (Message) Format Interpretation. |
|
Fromdate |
the date on which the search is to start. The format is 'YYYY-MM-DD'. This parameter can be coded either as a character string, for example, '2013-05-31', or as a numeric value, for example, 1130531. |
|
Todate |
the date on which the search is to stop. The format is 'YYYY-MM-DD'. This parameter can be coded either as a character string, for example, '2013-05-31', or as a numeric value, for example, 1130531. The default value for Todate is the current date. |
Note: This macro is not case sensitive. Uppercase and lowercase letters can be used interchangeably.
Usage Notes
The ListEvent macro is useful for obtaining a look at all occurrences of the desired event.
Example
The following statement generates a report of all 033- 13895 -00 events between May 5, 2013, and the date of today:
Exec ListEvent (0331389500, ’2013-05-05’,);
Example
The following statement generates a report of all 033-13895-00 events for the last seven days:
Exec ListEvent (0331389500, Date-06,);
Example
The following statement generates a report of all 033-12116-00 events between May 5, 2013 and May 18, 2013:
Exec ListEvent (0331211600, ’2013-05-05’ , ’2013-05-18’);
The resulting report follows:
13/05/18 All 33-12116-00 Events Between 2013-05-05 and 2013-05-18 13:51
Date Time Message Text
-------- --------------- -------------------------------------------------------
13/05/18 18:54:29.380000 13/05/18 18:54:26 Running DBS Version: 12m.00.00.00
Event number 34-02900-00 (severity 10, category 10)
18:54:29.420000 13/05/18 18:54:26 Running PDE Version: 12m.00.00.00
Event number 34-02900-00 (severity 10, category 10)
18:54:29.480000 13/05/18 18:54:26 AMP 0 has been selected as the Contro
Event number 34-02900-00 (severity 10, category 10)
18:54:29.520000 13/05/18 18:54:26 Redistribution minicasts are enabled
Event number 34-02900-00 (severity 10, category 10)
18:54:29.580000 13/05/18 18:54:26 The OCS System Profiles GDO has been
Event number 34-02900-00 (severity 10, category 10)
18:54:29.620000 Event number 34-02900-00 (severity 10, category 10)
13/05/18 18:54:27 Initializing DBS Vprocs
18:54:44.340000 13/05/18 18:54:44 Initializing DBS Configuration
Event number 34-02900-00 (severity 10, category 10)
18:54:45.010000 13/05/18 18:54:44 Configuration is operational
Event number 34-02900-00 (severity 10, category 10)
18:54:47.490000 13/05/18 18:54:47 Starting AMP partitions
Event number 34-02900-00 (severity 10, category 10)
18:54:48.060000 send_gtw_enable: sending
18:54:48.200000 May 05 18:54:48 Teradata DBS Gateway: [105]: error logg
18:54:49.960000 May 05 18:54:49 Teradata DBS Gateway: [105]: ycgsecurit
18:54:50.000000 May 05 18:54:50 Teradata DBS Gateway: [105]: ycgsecurit
May 05 18:54:50 Teradata DBS Gateway: [105]: ycgsecurit
May 05 18:54:50 Teradata DBS Gateway: [105]: ycgsecurit
May 05 18:54:50 Teradata DBS Gateway: [105]: ycgsecurit
18:54:54.740000 Event number 34-02900-00 (severity 10, category 10)
13/05/18 18:54:52 DBS RestartKind: COLD (Do not wait fo
18:54:54.850000 Event number 34-02900-00 (severity 10, category 10)