Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sys.fn_trace_getfilterinfo (Transact-SQL)

sys.fn_trace_getfilterinfo (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

Returns information about the filters applied to a specified trace.

System_CAPS_importantImportant

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Extended Events instead.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions


fn_trace_getfilterinfo ( trace_id )

trace_id

Is the ID of the trace. trace_id is int, with no default.

Returns the following information. For more information about the columns, see sp_trace_setfilter (Transact-SQL).

Column name

Data type

Description

columnid

int

The ID of the column on which the filter is applied.

logical_operator

int

Specifies whether the AND or OR operator is applied.

comparison_operator

int

Specifies the type of comparison made:

0 = Equal

1 = Not equal

2 = Greater than

3 = Less than

4 = Greater than or equal

5 = Less than or equal

6 = Like

7 = Not like

value

sql_variant

Specifies the value on which the filter is applied.

The user sets trace_id value to identify, modify, and control the trace. When passed the ID of a specific trace, fn_trace_getfilterinfo returns information about any filter on that trace. If the specified trace does not have a filter, this function returns an empty rowset. When passed an invalid ID, this function returns an empty rowset. For similar information about traces, see sys.fn_trace_getinfo (Transact-SQL).

Requires ALTER TRACE permission on the server.

The following example returns information about all filters on trace number 2.

SELECT * FROM fn_trace_getfilterinfo(2) ;
GO

Community Additions

ADD
Show:
© 2015 Microsoft