Dataware house report on Datastore and its corresponding Volume

jonas — Thu, 05 Jun 2025 05:40:51 GMT

Hi.

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?

Regards

Jonas

Re: Dataware house report on Datastore and its corresponding Volume

moechnig — Fri, 14 Mar 2014 03:44:56 GMT

There may be a GUI way to do this, but I've only done it with SQL. These Inventory tables will provide current data&colon;

dwh_inventory.hv_datastore_to_nas_share
dwh_inventory.hv_data_store_to_volume table
dwh_inventory.hv_data_store_to_internal_volume
dwh_inventory.hv_lun

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.

topic Dataware house report on Datastore and its corresponding Volume in Active IQ Unified Manager Discussions

Dataware house report on Datastore and its corresponding Volume

Re: Dataware house report on Datastore and its corresponding Volume