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)?
DX Performance Management 3.7
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 By "cpumfs" > DeviceItemID
Average Of > im_utilization
-expand: device > Name
-sort: Value > Desc
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: