Example: Generating a Statement of Events in the Past 60 Days - Analytics Database - Teradata Vantage

SystemFE Macros

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
iqw1628112378327.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
usl1472251351342
lifecycle
latest
Product Category
Teradata Vantageā„¢

The following statement provides counts of events for the last sixty days:

Exec EventCount (Date-60,);

The resulting report follows:

 *** 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.


Event Tags in report example