our customer is asking to provide one report for all routers/interfaces for the last 2 years (aka weekly data retention period) for every week (104 weeks in 2 years). It should look like this
Router name | interface name | week start – end | utilization.
Data should be present in DR, but the question is how to extract them in required format especially.
Did anyone have to create something similar in the past? Any idea is highly appreciated.
Have you reviewed the OpenAPI tools in PM?
OpenAPI - CA Performance Management - 3.1 - CA Technologies Documentation
That may be the better way to obtain the report w/ format being sought.