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?
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:
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.