Creating Utilization Report in DX NetOps CA Performance Management (CAPM) for very large number of Interfaces

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Is there a way to get a report of all interfaces (totally a very large number. For example; over 30,000) on routers/switches and show their utilization % in a tabular format?

To create a spreadsheet with router name in column A, interface name in column B, interface alias in column C, interface speed in column D, interface utilization in/out over the last N period of time in column E/F. 

The current views appear limited to 250. 

Environment

DX NetOps CAPM Release : 20.2 or later

Cause

30,000 rows is too much for the UI to handle with default settings.

Resolution

Using OpenAPI, you need to increase the query max in the odata config, as per:

TechDocs : DX NetOps CAPM 22.2 : Configure OpenAPI Defaults and Limits

So, set the following:

maxTopLimit = 30000

timeout     = 120

or increase:
defaultQueryTimeoutSecs = 120

otherwise query may time out after 30 secs.

NOTE: Increasing these settings will result in longer response times when generating the output.