16.20 - Example: Generating a Statement of Events in the Past 60 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 provides counts of events for the last sixty days:

Exec EventCount (Date-60,);

The resulting report follows:

EXECUTE EventCount (Date-60,);
 *** Echo accepted.
 *** Total elapsed time was 1 second.
 *** Echo accepted.
 *** Echo accepted.
 *** Echo accepted.
 *** Echo accepted.
 *** Echo accepted.
 *** Echo accepted.
 *** Echo accepted.
 *** Query completed. One row found. 4 columns returned.
14/04/04                       Total Of Each Event                         10:44
                       Between 2014-02-03 and 2014-04-04
                                            Total
                              Event Tag  Occurrences
                           ------------  -----------
                            33-10198-00            5
 *** Echo accepted.

The following figure shows how to interpret the Event Tags included in the report.