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

SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
kak1592015099875.ditamap
dita:ditavalPath
kak1592015099875.ditaval
dita:id
B035-1103
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.