db.teradata

[ 1 Introduction ] [ 2 Valid tags and data tables ] [ 3 Table structure ]

Introduction

The tags beginning with db.teradata identify events belonging to Teradata.

Valid tags and data tables

The full tag must have at least three levels. The first two are fixed as db.teradata. The third level identifies the type of events sent. The fourth level indicates the event subtype.

These are the valid tags and corresponding data tables that will receive the parsers' data:

Product / Service	Tags	Data tables

Product / Service	Tags	Data tables
Teradata	`db.teradata.out`	`db.teradata.out`

For more information, read more about Devo tags.

Table structure

These are the fields displayed in this table:

Field	Type	Extra field

Field	Type	Extra field
eventdate	`timestamp`
environment	`str`
event	`str`
logDate	`timestamp`
collectTimeStamp	`timestamp`
queryID	`str`
userName	`str`
logonSource	`str`
appID	`str`
clientID	`str`
clientAddr	`ip4`
queryBand	`str`
sqlTextInfo	`str`
sessionNo	`str`
logonDate	`str`
logonTime	`float8`
clientIpAddress	`ip4`
clientProgramName	`str`
clientSystemUserId	`str`
clientProcThreadId	`str`
clientTcpPortNumber	`str`
clientTdHostName	`str`
clientVmName	`str`
clientVmUserId	`str`
mechanismName	`str`
clientTDPReleaseId	`str`
clientCLIv2ReleaseId	`ip4`
clientSessionDesc	`str`
clientWorkload	`str`
clientJobData	`str`
clientODBCDriverVersion	`str`
clientNetDataProviderVersion	`str`
clientODBCDriverManagerVersion	`str`
clientNetFrameworkVersion	`str`
clientAttributesEx	`str`
clientJDBCDriverVersion	`str`
clientJavaVersion	`str`
recoverableNetworkProtocol	`str`
logonRedrive	`str`
clientIPAddrByClient	`ip4`
clientPortByClient	`str`
serverIPAddrByClient	`ip4`
serverPortByClient	`str`
serverIPAddrByServer	`ip4`
serverPortByServer	`str`
clientCOPSuffixedHostName	`str`
userAuthenticatedBy	`str`
clientTDSessionPoolName	`str`
securityPolicy	`str`
dirUserNetConfidentiality	`str`
dirUserNetPolicyLevel	`str`
effectiveSessionNetConf	`str`
effectiveSessionNetPolicyLevel	`str`
proxyLogon	`str`
errorCode	`str`
errorMsg	`str`
hostchain	`str`	✓
tag	`str`	✓
rawMessage	`str`