Creating a Analyzer detail view report using MQL

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

MQL is intended for more complex operations than the Query Builder. This includes operations such as interval rollup and resource rollup. Refer to the Hitachi Ops Center Analyzer Detail View Query Language User Guide for details. You can write a query from the scratch or you can extend the queries of built-in reports.

  1. In the Analyzer detail view left pane, select Reports > Build.
    The Build window opens.
  2. Click Create Using MQL.
  3. Enter a query in the Enter MQL box:
    • Writing queries from the scratch: For example, the following query uses the interval rollup operation to aggregate data from a lower interval to a higher interval:
      raidPG[@utilization rx b .*]{intervalRollUpOp=AVG,outputIntervalInSec=3600}

      By default, the collection interval of utilization metric of the RAID PG group is 300 seconds. This example query uses 3600 seconds (outputIntervalInSec) query filter option.

    • Extending queries of built-in performance reports: To extend queries of existing reports, do the following:
      1. Go to resource tree node.
      2. In a chart report area, click the icon and select Options > Show Query and then copy the query.
      3. Go back to Reports > Build.
      4. Paste the query in the Enter MQL box.
      5. Edit the query as required.
  4. In the Duration box, select the length of time to run the query (maximum 7 days).
  5. Click View Result.
    The View Result window opens.
  6. In the View Result window, click Save Query and enter a name.
  7. Click Save. The query is saved and listed in the Build window.