Table of Contents | ||||
---|---|---|---|---|
|
Introduction
The tags beginning with db.
db2mssql
identify events generated by IBM Db2 Database Microsoft SQL Server.
Valid tags and data tablestables
The full tag must have at least 6 three levels. The first three two are fixed asdb.
db2.auditmssql
. The third level identifies the type of events sent. The fourth, fifth, and sixth levels identity the corresponding environment, application, and clone. An additional tag may be required to specify the type of the logs sent (CSV or key-value pairs)
...
Technology
...
Brand
...
Type
...
Environment
...
Application
...
Clone
...
Data type
...
db
...
db2
...
audit
...
<env>
...
<app>
...
<clon>
...
csv
kvp
These are the valid tags and corresponding data tables that will receive the parsers' data:
Tag
Product / Service | Tags | Data tables |
---|---|---|
Microsoft SQL Server |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
For more information, read more about Devo tags.
Table structure
These are the fields displayed in these tables:
...
...
...
...
Anchor | ||||
---|---|---|---|---|
|
...
How is the data sent to Devo?
...
mssql.audit
Field | Type | Source field name | Extra fields |
---|---|---|---|
eventdate |
| ||
environment |
| venv | |
application |
| vapp | |
clon |
| vclon | |
message |
| ||
rawMessage |
| rawSource | ✓ |
hostchain |
| ✓ | |
tag |
| ✓ |
Anchor | ||||
---|---|---|---|---|
|
Field | Type | Field transformation | Source field name | Extra fields | ||
---|---|---|---|---|---|---|
eventdate |
|
|
| |||
environment |
|
| venv | |||
application |
|
| vapp | |||
clon |
|
| vclon | |||
date |
|
| date_str | |||
source |
|
|
| |||
message |
|
|
| |||
database |
|
|
| |||
creation_date |
|
|
| |||
first_LSN |
|
|
| |||
last_LSN |
|
|
| |||
number_device |
|
|
| |||
device_information |
|
|
| |||
extMessage |
|
|
| |||
hostname |
|
|
| |||
host_ip |
|
|
| |||
host_ip_str |
|
|
| |||
tag |
|
|
| ✓ | ||
rawMessage |
|
|
| ✓ | ||
hostchain |
|
|
| ✓ |
Anchor | ||||
---|---|---|---|---|
|
Field | Type | Source field name | Extra fields |
---|---|---|---|
eventdate |
| ||
environment |
| venv | |
application |
| vapp | |
clon |
| vclon | |
hostname |
| ||
user |
| ||
eventTime |
| ||
hostname2 |
| ||
keywords |
| ||
eventType |
| ||
severityValue |
| ||
severity |
| ||
eventID |
| ||
sourceName |
| ||
task |
| ||
recordNumber |
| ||
processID |
| ||
threadID |
| ||
channel |
| ||
message |
| ||
category |
| ||
eventReceivedTime |
| ||
sourceModuleName |
| ||
sourceModuleType |
| ||
syslogFacilityValue |
| ||
syslogSeverityValue |
| ||
costCenter |
| ||
configurationItem |
| ||
teamEmail |
| ||
hostchain |
| ✓ | |
tag |
| ✓ | |
rawMessage |
|