Subscribe

Dataware house report on Datastore and its corresponding Volume

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

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_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.