[OCI DWH] Find all NetApp Storage Virtual Machines (SVMs/Vservers) in the OCI DWH

 Just a simply query to get all the Storage Virtual Machines - that we know of - from the NetApp OnCommand Insight DataWarehouse:

SELECT DISTINCT virtualStorage

FROM dwh_inventory.internal_volume AS iv

JOIN dwh_inventory.storage AS s ON s.id = iv.storageId

WHERE s.microcodeVersion LIKE '%clustered%'



Comments