Effective December 3, NetApp adopts Microsoft’s Business-to-Customer (B2C) identity management to simplify and provide secure access to NetApp resources.
For accounts that did not pre-register (prior to Dec 3), access to your NetApp data may take up to 1 hour as your legacy NSS ID is synchronized to the new B2C identity.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

Dataware house report on Datastore and its corresponding Volume

jonas

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

1 REPLY 1

moechnig

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. 

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public