Extract of metric data for time period
search cancel

Extract of metric data for time period

book

Article ID: 261765

calendar_today

Updated On:

Products

DX Operational Intelligence

Issue/Introduction

Is there a way to extract the metric data for all entities for a time period?

Resolution

The issue came up in part since capacity analytics won't work. Some fixes and new features went in recently. We saw Gaps in the data that were due to server issues. 

So was looking at other possibilities. We did not talk much about dashboards. But focused instead on extraction.

Options :

0) Get Capacity Analytics working

1) Use REST API https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/dx-apm-saas/SaaS/api-reference/apm-rest-api/Metric-Query-REST-API.html

2) Use NASS SQL. Doc links mailed to Mark.  From Engr: They can do queryAll from metadata for a specific time range and then query for those metrics from NASS for that range.
Or do that at once through nassql. See Attachments

This could be a lot of data . So maybe run daily/weekly instead of quarterly

3) query in excel use nas as the data source
https://www.howtoexcel.org/how-to-access-a-json-api-with-power-query/

Attachments

1678487041690__Metric Store (NASS) (1).pdf get_app
1678487017557__Metric Metadata.pdf get_app