Skip to Content

Working with filters

After you add a category to a report view, you are redirected to the workflow view. The workflow view includes a filter bar. The filter bar contains the categories and metrics that you selected in the Add Category pane. The filter bar displays the filters associated with the selected category and metric.


Related topics

Managing-report-views

Using-Filter-Actions

Managing-alerts

To use filter options

  1. In the Categories field, select a category.
    The Metrics field displays all the selected metrics from the current category. You can select or unselect metrics from this list. 
    For more information about adding categories, see Working-with-reporting-categories.
    image-2024-9-16_19-51-7.png

    Warning

    Important

    When you select a category, the filter bar displays filters specific to that category. When you change the category, one or more filters on the filter bar might change. Some of the filters are as follows:

    • Sysplex
    • CPC Name
    • SMF ID
    • System Name

    Selecting the Show Advanced Metrics option in the Metrics field displays the advanced metrics in the list. 
    The filter selections work from left to right. Changing an object in a filter invalidates all filter selections that are on the right.

    image2022-10-27_10-31-54.png

    Warning

    Important

    Use filters to reduce the amount of data returned from the query. Selecting ALL in the filters might result in queries returning large amounts of data. 

  2. (Optional) Use the Search field to restrict the displayed filters.
    You can use wildcard characters. For more information, see To use filter values and wildcard characters in the search field.
    To get the complete list of the filter values, clear all text in the Search field.
    image2022-10-27_10-34-2.png

  3. (Optional) Select the Aggregate Selections check box to aggregate all selections in a filter to a single object, and aggregate all selections in a filter to a single object called aggr.
    When you select the Aggregate Selections check box for a given filter, theimage2022-10-27_10-36-53.pngsymbol indicates that the selections for that filter item are aggregated.
  1. Click one of the following options to run a query based on your requirement: 
    image-2024-9-13_17-11-4.png

    • Run Query: Runs the query for the currently selected category only. It does not produce an alert preview.
    • Run Query For All Categories: Available when the report view has more than one category. It does not produce an alert preview.
    • Run Query with Alerts: Available when at least one metric in the selected category has an attached alert rule. The generated alerts are displayed in the Alert Preview.

    • Run Query With Alerts For All Categories: Available when a report view has more than one category and at least one metric with an attached alert rule. The generated alerts are displayed in the Alert Preview.
      For more information about attaching alert rules, see Managing-alerts.

      Warning

      Important

      If the request returns a large amount of data, the tool displays a warning. You can still proceed with the query though it might take a long time to complete.

      The current report view displays the data.

To use filter values and wildcard characters in the search field

In the filter bar, when you use the filter values and wildcard characters in the search field, the following conditions apply: 

Filter values/Wildcard 

Result 

Example

Any value

Exact match

Entering CM returns CM only, but not CM01, CM123, and so on.

"*"

Matches any number of characters starting from 0

Entering "CM*" returns a match of CM, CM01, CM123, and so on.

?

Matches exactly one character in the value entered

Entering CM?2 returns a match of CM12, CM22, CM32, and so on.

(Prefix) !

Matches all the strings that do not match values using this prefix.

Entering !CM returns a match of all values except CM.

Entering !CM* returns a match of all values except CM, CM01, CM123, and so on.

Entering !CM?2 returns a match of all values except CM12, CM22, CM32, and so on.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Capacity Reporting 24.4