OCI DWH SQL Query: Find all CDOT Clusters with Not Local Acquisition Unit (i.e using RAU)

SELECT
  au.siteName AS 'AU Site',
  au.Name AS 'AU Name',
  au.ip AS 'AU IP',
  ds.name AS 'DS Name',
  ds.model AS 'DS Model'
FROM acq_data_source AS ds
JOIN acq_acquisition_unit AS au ON ds.acquisitionUnitId = au.id
AND au.name != 'local'
WHERE ds.model = 'Clustered Data ONTAP 8.1.1+'; 

Image: The query in MySQL Workbench

Comments