PM - How to report in OpenAPI the CPU Utilization ordered by Utilization Average for items that belong to a particular Collection

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Is there any example of OpenAPI query expression to report the full list of CPU Utilization ordered by Utilization Average for items that belong to a particular Collection (eg "Odata" Collection)?

Environment

DX Performance Management 3.7

Resolution

Below an example of OpenAPI query expression to generate such report:

-for: Metric Family > cpumf
-filter: groups/Name equal "Odata" (or, contains "Odata")
-time range: in this example we have selected the last 30 days with Time Granularity set to "Day"

-group/aggregate: 
        Group By "cpumfs" > DeviceItemID
        Average Of > im_utilization

-expand: device > Name
-select: value
-sort: Value > Desc
-limit: 
        Maximum number of rows: 20000
        Number of rows to skip: 0
        Maximum number of expanded rows: 1

Then hit Run button to generate the report: