xEvents - Filter Operators

• shindle 17293

  Ten Centuries

  Points: 1374

  More actions

  August 3, 2017 at 8:36 pm

  #327841

  Hi there

  Can someone explain the difference between the equal_i_sql_unicode_string, equal_i_unicode_string and equal_unicode_string Operators in xEvents?

  I am using a filter: database_name - not_equal_i_sql_unicode_string - tempdb but these are still appearing in the captured events? As an alternative, when I choose <>, after saving it changes it to not_equal_i_sql_unicode_string?

  Thanks in advance

  Steve

• shindle 17293

  Ten Centuries

  Points: 1374

  More actions

  August 3, 2017 at 10:40 pm

  #1954073

  I think I figured out this bit:

  "I am using a filter: database_name - not_equal_i_sql_unicode_string - tempdb but these are still appearing in the captured events?"

  I should have used the sqlserver.database_name for the Filter Field and not just database_name - so looks like "equal_i_sql_unicode_string" should be used when the Filter Field is "sqlserver.*"