Hello Guys,
I am trying to get the list of snapshots from the selected volume and delete the selected snapshot.
I am trying to query the snapshots from the volume, but for some reasons its not working:
SELECT
snapshot.name as 'snapshot.name'
FROM
storage.volume as volume,
storage.array as array,
storage.aggregate,
storage.snapshot
WHERE
snapshot.volume_id = volume.id
and volume.name = '${volume}'
and aggregate.array_id = array.id
and aggregate.id = volume.aggregate_id
and aggregate.name = '${aggr}'
AND (
array.ip = '${storage}'
OR array.name = '${storage}'
)
I am also attaching the a part of the workflow which shall list the storage/volume/aggr and snapshots that needs to be deleted.
Need your help to get the list of the snapshots from the query and then i can proceed further.
,Sheel
