Jump to main content

# Create queries using the Create Query wizard

Performance management queries can be created for certain statistics categories and their associated instances.

## About this task

The Create Query wizard is launched from the Create Report dialog box. For more information about creating a report, see Create performance reports.

For some categories, you can configure the query to return the n most active instances. This feature is available for the following categories:

Category | Metrics
--- | ---
Storage Group | Host IOs/sec (default) Host MBs/sec Response Time
Storage Group Volumes | Host IOs/sec (default) Host MBs/sec Response Time
RFDS Group | Host IOs/sec (default) Host MB/Sec Response Time
RFDA Group | RDF R1 to R2 IOs/sec (default) RDF R1 to R2 MBs/sec RDF Response Time Host Writes/sec Host MBs Written/sec

To create a query using the Create Query wizard:

## Steps

1. When creating a report, in the Create Report dialog box, click Create to open the Create Query wizard.
2. In the Query & Description page, enter a query Name.
3. Optional: Enter a query Description.
4. Click Next.
5. In the Category & Instances page, select a Category.
   Depending on the category type you select, different options are presented.
6. Specify appropriate Instances.
   Some or all of the following options are available:

   All | Displays all instances.
   Specific | Displays the specific instances that you select. Select them in the Available Instances list and click > to move them to the Selected Instances list. You can use multiselect for multiple instances. If required, you can filter the instances by name.

   Most Active | Displays the top n most active instances. You can specify a value for n and the metric by which you want to sort the displayed instances.

7. Click Next.
8. In the Metrics page, select a Data Format. The available options are Average and Maximum.
9. Select the Metrics (for the category and data format you selected on the Category & Instance page of the wizard). Select them in the Available Metrics list and click > to move them to the Selected Metrics list. You can use multiselect for multiple metrics. You can use multiselect for multiple metrics. If required, you can filter the metrics by name.
10. Click OK.