Need to get the average cpu utilization of device instead of individual cpu cores using OpenAPI

Products

• CA Performance Management
• Network Observability

Issue/Introduction

We are trying to get the average CPU utilization data of a device using OpenAPI Odata QueryBuilder but end up getting the data for all the CPU cores. We need to fetch the data for average CPU utilization instead of individual CPU cores, but we are unable to get it.

Environment

All supported DX NetOps Performance Management releases

Cause

To accomplish this, one would need to utilize the group/aggregate function within the QueryBuilder.  One thing to note is you will not be able to add an expand function to it or that will undo the group/aggregate function.

Resolution

This can be accomplished by setting up the Query Builder like so: