[OCI DWH MySQL] Find All NAS (NFS) Hosts Connected to a Storage Array

on

SELECT
    h.name AS 'host'
  , s.name AS 'storage'
FROM dwh_inventory.nas_logical AS n
JOIN dwh_inventory.host AS h ON n.hostId = h.id
JOIN dwh_inventory.storage AS s ON n.storageId = s.id
WHERE s.name = 'YOURSTORAGENAME'

Comments

Post a Comment