Skip to main content

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.
FileDescriptionSyntax and example
omitarlist.txtActivity 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,application
SQLPlan,Ent-SQL,Table,guest,WksSQL,MyInternalApp
omitdcpathlist.txtObjects whose data categories to hide in search and reports.instance:resource path
njsrv54:Databases\*\Tables\*
omiterrorlist.txtErrors and warnings to exclude from the Netwrix Auditor System Health event log.monitoring plan,item,error text
*,sqlserver1.corp.local,*Access is denied*
omitlogonlist.txtLogons to exclude from monitoring. Logon types: NtLogon, SqlLogon, NtFailedLogon, SqlFailedLogon.monitoring plan,instance,logon type,account,workstation,application
SQLPlan,Ent-SQL,SqlFailedLogon,guest,WksSQL,MyInternalApp
omitobjlist.txtObject types to hide from reports, search, and Activity Summaries. Auditor still collects the data.object type, as shown in the "Object type" column
Database
omitpathlist.txtObjects 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" column
PROD.SQL2012:Databases\tmp*
omitproplist.txtAttributes to exclude from monitoring and from the Long-Term Archive.object type.property.attribute; use * if there's no attribute
Database.Database File.Size
omitreadaccesslist.txtSELECT statements to exclude from auditing. The third field is always ReadAccess.monitoring plan,instance,ReadAccess,account,workstation,application
SQLPlan,Ent-SQL,ReadAccess,guest,WksSQL,MyInternalApp
omitsitpathlist.txtObjects to exclude from state-in-time data collection. Don't exclude the master database.instance:resource path
njsrv54:Databases\tmp*
omitstorelist.txtObjects to exclude from data collection and reporting. Doesn't affect the triggerless mode, SELECT statement auditing, and logon monitoring.instance:resource path
njsqlsrv23*:Security\Server Roles\*
omittracelist.txtInstances on which Auditor doesn't enable SQL tracing. See Configuring Trace Logging.server\instance
*\SQLExpress
propnames.txtFriendly names for object types and properties in change reports.object type.property=friendly name
*.Date modified=Modification Time