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.
DX NetOps CAPM Release : 20.2 or later
30,000 rows is too much for the UI to handle with default settings.
Using OpenAPI, you need to increase the query max in the odata config, as per:
So, set the following:
maxTopLimit = 30000
timeout = 120
defaultQueryTimeoutSecs = 120
otherwise query may time out after 30 secs.
NOTE: Increasing these settings will result in longer response times when generating the output.