SQL Server Monitoring Scope
You can fine-tune Netwrix Auditor by specifying data that you want to exclude from the SQL Server monitoring scope.
Exclude data from the monitoring scope
Step 1 – Navigate to the %Netwrix Auditor install folder%\SQL Server Auditing folder.
Step 2 – Edit the *.txt files, based on the following guidelines:
- Each entry must be a separate line.
- You can use a wildcard (*) to replace any number of characters.
- Auditor ignores lines that start with the # sign; use them for comments.
| File | Description | Syntax and example |
|---|---|---|
| omitarlist.txt | Activity records to hide from reports, search, and Activity Summaries. Doesn't affect the triggerless mode, SELECT statement auditing, and logon monitoring. | monitoring plan,instance,object type,account,workstation,applicationSQLPlan,Ent-SQL,Table,guest,WksSQL,MyInternalApp |
| omitdcpathlist.txt | Objects whose data categories to hide in search and reports. | instance:resource pathnjsrv54:Databases\*\Tables\* |
| omiterrorlist.txt | Errors and warnings to exclude from the Netwrix Auditor System Health event log. | monitoring plan,item,error text*,sqlserver1.corp.local,*Access is denied* |
| omitlogonlist.txt | Logons to exclude from monitoring. Logon types: NtLogon, SqlLogon, NtFailedLogon, SqlFailedLogon. | monitoring plan,instance,logon type,account,workstation,applicationSQLPlan,Ent-SQL,SqlFailedLogon,guest,WksSQL,MyInternalApp |
| omitobjlist.txt | Object types to hide from reports, search, and Activity Summaries. Auditor still collects the data. | object type, as shown in the "Object type" columnDatabase |
| omitpathlist.txt | Objects to hide from reports, search, and Activity Summaries. Auditor still collects the data. Doesn't affect the triggerless mode. | instance:resource path, as shown in the "What" columnPROD.SQL2012:Databases\tmp* |
| omitproplist.txt | Attributes to exclude from monitoring and from the Long-Term Archive. | object type.property.attribute; use * if there's no attributeDatabase.Database File.Size |
| omitreadaccesslist.txt | SELECT statements to exclude from auditing. The third field is always ReadAccess. | monitoring plan,instance,ReadAccess,account,workstation,applicationSQLPlan,Ent-SQL,ReadAccess,guest,WksSQL,MyInternalApp |
| omitsitpathlist.txt | Objects to exclude from state-in-time data collection. Don't exclude the master database. | instance:resource pathnjsrv54:Databases\tmp* |
| omitstorelist.txt | Objects to exclude from data collection and reporting. Doesn't affect the triggerless mode, SELECT statement auditing, and logon monitoring. | instance:resource pathnjsqlsrv23*:Security\Server Roles\* |
| omittracelist.txt | Instances on which Auditor doesn't enable SQL tracing. See Configuring Trace Logging. | server\instance*\SQLExpress |
| propnames.txt | Friendly names for object types and properties in change reports. | object type.property=friendly name*.Date modified=Modification Time |