Hi Guys,
I am trying to write a Workflow to get a list of all "offline" volume in a filer.
I have written a below SQL Query which will give me a list of volumes which are "offline" or have an gaurantee as "volume"
Now i m trying to get this complete output in a mail but unable to get it done. I have created a filter also but unable to proceed further.
Kindly help
BR
Raj
SELECT
volume.name,
volume.state,
volume.volume_guarantee
FROM
storage.volume,
storage.array
WHERE
(
storage.array.name = '${array}'
OR storage.array.ip = '${array}'
)
AND volume.array_id = array.id
AND (
volume.state not like "online"
OR volume.volume_guarantee = 'volume'
)