How can we use wildcards in USM Group filters

Document ID : KB000010063
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

When creating group containers you can use SQL wildcards to do more advance matching.

Environment:
CA UIM 8.1 and aboveMS SQL Server
Instructions:

You can use the following special characters within the USM Group Filters.

  • % : A substitute for zero or more characters
  • _ : a substitute for a single character
  • [characterList] : Sets and ranges of characters to match
  • [!charlist] or [^charlist] : Matches only characters NOT in the brackets

Note; these will only work when the filter operator is a "contains", "starts with" or "ends with". It will not work with "is" or "in".

 

 

Additional Information:

USM Group Filters