ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 226378

calendar_today

Updated On:

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:

 

Attachments