17.00 - 17.05 - Example: Generating a Statement of Events in the Past 60 Days - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Administration
Publication ID
B035-1103-170K
Language
English (United States)

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.