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
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
Post a Comment