Hi Raj,
What are you ultimately trying to achieve or automate once you have this information?
As you've mentioned MySQL as an option are you using WFA as the source for your query?
If so you could use something like:
For 7-Mode:
#'---------------------------------------
#'Select the empty data volumes.
#'---------------------------------------
SELECT
volume.name AS 'volume_name',
aggregate.name AS 'aggregate_name',
vfiler.name AS 'vfiler_name',
array.name AS 'controller_name',
array.ip AS 'controller_address'
FROM
storage.volume,
storage.aggregate,
storage.vfiler,
storage.array
WHERE
volume.vfiler_id = vfiler.id
AND
vfiler.array_id = array.id
AND
volume.aggregate_id = aggregate.id
AND
volume.used_size_mb = 0;
#'---------------------------------------
For cDOT
#'---------------------------------------
#'Select the empty data volumes.
#'---------------------------------------
SELECT
volume.name AS 'volume_name',
aggregate.name AS 'aggregate_name',
vserver.name AS 'vserver_name',
node.name AS 'node_name',
cluster.name AS 'cluster_name',
cluster.primary_address
FROM
cm_storage.volume,
cm_storage.aggregate,
cm_storage.vserver,
cm_storage.node,
cm_storage.cluster
WHERE
volume.vserver_id = vserver.id
AND
vserver.cluster_id = cluster.id
AND
volume.aggregate_id = aggregate.id
AND
aggregate.node_id = node.id
AND
volume.junction_path <> '/'
AND
volume.used_size_mb = 0;
#'---------------------------------------
Note: or change 'volume.used_size_mb <= {$VolumeSizeMB}' assuming you want to enumerate volumes of a small (but not totally empty) size.
/matt
If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.