Table of Contents | ||||
---|---|---|---|---|
|
Introduction
The tags beginning with db.mssql
identify events generated by Microsoft SQL Server.
Valid tags and data tablestables
The full tag must have at least 3 three levels. The first two first are fixed asdb.mssql
. The third corresponds to level identifies the type of logs sent.
...
Technology
...
Brand
...
Type
...
db
...
mssql
...
error
audit
events
events sent. The fourth, fifth, and sixth levels identity the corresponding environment, application, and clone.
These are the valid tags and corresponding data tables that will receive the parsers' data:
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 | ||||
---|---|---|---|---|
|
...
.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 |
|