Dataware house report on Datastore and its corresponding Volume
2014-03-13 05:19 AM
Im using the datawarehouse to make a report on the datasource and its correwsponding volume.
That is easy se in the OCI console, but does anyone has a qlue how to make this kind of report?
1 REPLY 1
Re: Dataware house report on Datastore and its corresponding Volume
2014-03-13 08:44 PM
There may be a GUI way to do this, but I've only done it with SQL. These Inventory tables will provide current data:
- dwh_inventory.hv_data_store_to_volume table
That's what I've used in the past for this sort of query.
Among the marts with time-series data, dwh_capacity.vm_capacity_fact can be used to tie a datastore back to its qtree or internal volume, if you're using those. For block storage, it can get you back to the array and even the backend array if you're using a virtualizer but it doesn't seem to include the volume.