Extraction of metric data for a specific time period

Products

• DX Operational Intelligence

Issue/Introduction

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

Resolution

There are a few ways:

1) Configure Capacity Analytics

2) Use Metric Query REST API

2) Use NASS SQL. You 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. 

This could be a lot of data . So you may want to run daily/weekly instead of quarterly

3) Query in excel using nas as the data source
How To Access A JSON API With Power Query