Creating a report using Query Builder

Ops Center Analyzer Detail View User Guide
Version
11.0.x
Audience
anonymous
Part Number
MK-99ANA007-06
ft:lastEdition
2026-03-16

The Query Builder helps you generate reports with a simple UI. It allows you to select the resource and apply filters. For example, you can run a simple query that shows the list of LDEVs across the same resource (such as, Hitachi Enterprise storage system).

The query is built on the following:
  • Resource group: Resource groups are the types of targets that are monitored using the Analyzer probe. For example, if you want to troubleshoot an Hitachi Enterprise storage system, you must select the Hitachi Enterprise Storage resource group.
  • Resource: There can be multiple resources associated with a resource group. For example, the pool, LDEV, and MPB are resources associated with Hitachi Enterprise Storage resource group.
  • Filter: Use the filter to select the metrics associated with a resource. For example, if you select the Pool resource, the pool ID and total IOPS are available as filters. In a query, you can add multiple filters for a resource.
  1. In the Analyzer detail view left pane, select Reports > Build.
    The Build window opens.
  2. Click Create Using Query Builder.
  3. In the Create Using Query Builder window, use the Select Resource box to start building a query.

  4. Let's assume you want to build a query that shows the total IOPS of the LDEVs associated with Hitachi Enterprise Storage system serial number 421358.
    1. Select the Resource Group and Resource that you want to query.

      In this example, we will select the Hitachi Enterprise Storage resource group and the Storage System resource.

      After selecting the resource group and resource, the Resource and Filter options are enabled and a message to drag and drop the Filter or Resource is displayed.

    2. To add the filter, drag the Filter icon as follows:

      The Enter Filter Details box is added next to the Select Resource box.

    3. Select the Filter. Metrics corresponding to resource are listed. After you select the metric, you have the option of drilling down your query by applying filters:
      • If a configuration metric is selected, you can enter a string in the like box. You can also enter a regular expression.
      • If a performance metric is selected, you can apply the conditions like (Any, between, less than, or more than) for (at least, at most, or exactly) samples.

      To query storage system serial number 421358, we will select the Serial No. metric and then enter 421358 in the like box.

    4. To query the total IOPS of LDEVs, you must add the LDEV resource. Drag the Resource icon as follows:

    5. Select the Hitachi Enterprise Storage resource group and LDEV resource.

    6. Drag the Filter icon and select the Total IOPS filter (apply other filters as required). For creating the sample report, make sure that you have created the query as shown in the following example.

    7. In Duration, select the length of time to run the query (maximum 7 days).
    8. Click View Result.
      The View Result window opens. See Viewing reports in Report Builder for more details.

      Note:
      • An asterisk (*) in the breadcrumb indicates that the query is not yet saved. If you want to make any changes, you can use the breadcrumb to return to Create Using Query Builder window.
      • You can drill down by applying multiple filters for resources as shown in the following example.

      • You can add multiple resources as shown below. A maximum of two resources can be viewed in the report. For example, if three resources are added in a query, then the top 1 resource will be excluded in the report. In the following example, the Storage System resource is excluded and not be shown in the report.

        If you delete any resource from the query, the resource will be enabled in reverse order.

      • You can exclude resources from the report using the icon in the Select Resource box.
  5. In the View Result window, click Save Query and enter the query name.
  6. Click Save. The query is saved and listed in the Build window.