AuditTrail Example - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Example: Using AuditTrail

CALL TDSTATS.AuditTrail('{"DatabaseName":"AuditTrail_DB"}’);

*** ResultSet# 1 : 12 rows returned by "TDSTATS.AUDITTRAIL".

EventTimeStamp       2022-01-18 15:13:37
DatabaseName         AuditTrail_DB
TableName            tab_with_missing_recs
FieldNames           x1
StatsOrIndexId       2
SCOID                300,007
DDLText              COLLECT STATISTICS COLUMN("X1") ON "AuditTrail_DB"."tab_with_missing_recs";
StatsSubmitted       1
StatsCollected       1
UtilityName          ?
InsertCount          ?
UpdateCount          ?
DeleteCount          ?
ErrorText            ?
Description.         Initial collection or refresh of single stat

....