How to Export KPIs with Min/Max Timestamps in DX NetOps Performance Management

Products

• Network Observability

Issue/Introduction

Users require a data export that includes specific KPIs and fields in a tabular format, including:

• Device name

• Subelement name/index

• Formula name

• Max/Min Values and their associated Max/Min Dates

• Aggregated data (Sum, Avg)

• Interface details (IfHighSpeed, AP_ifType, IfColumn1)

 

Environment

DX NetOps Performance Management

Cause

Currently, standard on-demand reporting does not allow for pinpointing the exact time of the Min/Max values within the generated report.

Resolution

Standard on-demand reporting in NetOps PM provides the closest available data but lacks the granularity to show the exact timestamp for specific Min/Max value occurrences.

To achieve the level of detail required—specifically retrieving data with exact timestamps—you must use OData queries via the OpenAPI. By constructing a specific OData query, you can include the timestamp fields necessary to retrieve data that matches the requirements shown in your template.

Steps to Implement:

1. Identify the specific metric family and attributes required for the export.

2. Construct an OData query URL targeting the Performance Center OpenAPI.

3. Include the timestamp and value attributes in the $select or $expand parameters of your query.

4. Execute the query via a REST client or browser to verify the output format.

Additional Information

Detailed guidance on how to construct these queries can be found in the NetOps Performance Management documentation:

• OpenAPI Documentation: https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/25-4/apis/openapi.html