How to view filter information (Transact-SQL)

To view filter information

• Execute fn_trace_getfilterinfo specifying the ID of the trace on which filter information is needed. This function will return a table listing the filters, the column on which the filters are applied, and the value on which the filter is applied.

  Invoke the function this way:

  SELECT *
  FROM ::fn_trace_getfilterinfo(trace_id)
  

See Also

Creating and Managing Traces and Templates

fn_trace_getfilterinfo

System Stored Procedures (SQL Profiler Procedures)

Viewing and Analyzing Traces