Submit a ticketCall us

AnnouncementUpgrading SolarWinds Orion Platform products has never been easier!

The SolarWinds Orion Installer is an all-in-one application for installations and upgrades. You use one installer to install or upgrade multiple Orion Platform products and install or upgrade Additional Polling Engines, Additional Web Servers, and High Availability Servers.

Learn more in the SolarWinds Orion Installer.

Home > Success Center > Log & Event Manager (LEM) > LEM - Knowledgebase Articles > Create a Custom SQL Auditor Trace File (.tdf)

Create a Custom SQL Auditor Trace File (.tdf)

Table of contents
Created by Jason Dee, last modified by MindTouch on Jun 23, 2016

Views: 1,481 Votes: 1 Revisions: 25

Overview

The MSSQL Auditor is sending SQL events that are too numerous or simply not needed. This can be solved by modifying the SQL Auditor trace file to filter the events that are being sent to the LEM.

Environment

  • All LEM versions
  • All SQL Server versions

Steps

1. Import the trace template into SQL Profiler (double click the tdf.  located in C:\Program Files (x86)\SolarWinds Log and Event Manager MSSQL Auditor\tdfs by default).

2. Edit the template (File > Templates > Edit Template > Select our template) and open Events Selection tab.

3. Click on the Column Filters... button (you should be able to see a dialog similar to what is shown in the attached screenshot), select DBUserName column, and add the LIKE/NOT LIKE condition as applicable.

 

Edit Filter

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

4. Save the template, replace the one inside the C:\Program Files (x86)\SolarWinds Log and Event Manager MSSQL Auditor\tdfs folder with the file that is located at C:\Users\<user>\AppData\Roaming\Microsoft\SQL Profiler\12.0\Templates\Microsoft SQL Server\120

5. Restart the MSSQLAuditor service.

Last modified

Tags

Classifications

Public