[MySQL][OCI DWH] NetApp ONTAP Storage Virtual Machines List and NAS Interfaces

on

How to get a list of all the NetApp ONTAP NAS Storage Virtual Machines and their NAS interfaces from the NetApp OnCommand Insight Data Warehouse.


SELECT
  s.name AS 'Storage',
  i.virtualStorage AS 'SVM',
  GROUP_CONCAT(DISTINCT n.ipInterfaces) AS 'NAS IPs'
FROM dwh_inventory.internal_volume AS i
JOIN dwh_inventory.storage AS s ON s.id = i.storageId
JOIN dwh_inventory.nas_file_share AS f ON f.internalVolumeId = i.id
JOIN dwh_inventory.nas_share AS n ON n.fileShareId = f.id
WHERE s.microcodeVersion LIKE '%ONTAP%'
GROUP BY i.virtualStorage
ORDER BY 1,2




Comments

Post a Comment