You can classify filters, meters, throttles, workloads, utility sessions, and query sessions by request sources such as account name or client IP address.
- Do one of the following:
- From the ruleset toolbar, click Filters, Meters, Throttles, or Workloads.
- From the Sessions tab, click Query Sessions or Utility Sessions.
- Select an item or create one.
- Click the Classification tab.
- Select a request source criteria or add one.
- Select a Source Type from the list.
- Username
- Account Name
- Account String
- Profile
- Application
- Client IP Address[SQLE 17.20.00.00 and Higher] Select the Use actual client IP address check-box to use the actual client IP address instead of the network address.
- Client ID
- Do at least one of the following:
- Enter a match string and use the Include and Exclude buttons to add the match string. A match string can contain ? to match exactly one character or * to match zero or more characters.
- Select items from the list and use the Include and Exclude buttons to create your classification criteria. If there are more than 500 items, use the filter box to locate the items you want to select.
- Click OK.