You will need to create additional ODBC type to cater for the additional instances you wish to audit.

In order to create the additional ODBC type, all the settings will remain the same as the original MSSQL odbc type, except:

1. The name of the ODBC need to be different (e.g: MSSQL_2)
2. The location of the trace file need to be different (e.g: C:\trace\TimTrace2)

To create additional ODBC type

1. Go to overview -> Systme configuration -> services -> Universal Device Collection -> Manage ODBC Type

2. Click Add. Then fill in the following details

Name: MSSQL_2 (or any name differ from MSSQL)

Description: <optional>

Device Name: Microsoft SQL Server

Device desrciption: <optional>

Tag: MSSQL

Default Interval: 10 Seconds

Output field delimiter: ||

Data query: exec nic_aud_swap_trace 3, 'c:\Trace\Trace2', 1, 'WHERE StartTime > %TRACKING%'

Address column: <optional>

Level column: <optional>

EventID Column: EventClass

Max tracking query: Select getDate()

Tracking column:StartTime

Note: For this ODBC type, the trace file will be stored in C:\Trace folder of the SQL server. Please ensure the folder C:\Trace existed before you create this type.

3. Click Apply

4. Go to manage ODBC service and create a ODBC service for the 2nd instance. In the type, select the one you have just created. (Match it with the Name)

5. Repeat the same with other instances you have set up on the SQL server

6. Restart NIC ODBC service

Now you are able to collect trace file for all the instances in your SQL server