db.mssql
Introduction
The tags beginning with db.mssql
identify events generated by Microsoft SQL Server.
Valid tags and data tablesÂ
The full tag must have at least three levels. The first two are fixed as db.mssql
. The third level identifies the type of 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:
db.mssql.audit
Field | Type | Source field name | Extra fields |
---|---|---|---|
eventdate |
| Â | Â |
environment |
| venv | Â |
application |
| vapp | Â |
clon |
| vclon | Â |
message |
| Â | Â |
rawMessage |
| rawSource | ✓ |
hostchain |
|  | ✓ |
tag |
|  | ✓ |
 db.mssql.error
Field | Type | Field transformation | Source field name | Extra fields |
---|---|---|---|---|
eventdate |
| Â | Â | Â |
environment |
| Â | venv | Â |
application |
| Â | vapp | Â |
clon |
| Â | vclon | Â |
date |
| parsedate(date_str, dateformat("YYYY-MM-DD HH:mm:ss.SS")) | 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 |
|  |  | ✓ |
 db.mssql.events
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 |
| Â | Â |