filter SQL Query for VSM destination volume

[Richy_TH]

Hi All

Do anyone have sql query script to quries VSM base on exsiting destination volume.

i would like to create break work flow command but unable to find certification filter command in wfa.

if you guys have any idea or example script please share.

Brs,

Richy 

[Richy_TH]

Dear All

it's for 7-mode Filer.

Brs,

Richy

[Richy_TH]

Dear All

i was tied to duplicate procedure of certificate Filter "Filter SnapMirror relationship by destination volume" for cm_storage into my own sql query for VSM 7-mode.

so the sql query show as below:

SELECT
vsm.id,
src_volume.name AS 'volume.name',
dest_volume.name AS 'secondary_volume.name',
src_array.ip AS 'volume.array.ip',
dest_array.ip AS 'secondary_volume.array.ip'
FROM
storage.vsm,
storage.array src_array,
storage.array dest_array,
storage.volume src_volume,
storage.volume dest_volume
WHERE
vsm.secondary_volume_id = dest_volume.id
AND vsm.volume_id = src_volume.id
AND dest_array.ip = ‘${array_ip}’
AND dest_volume.name LIKE '${dest_volume}'

but found error which not pointable the error show as below.

if anyone have any idea about my issue please let me know.

PS. i used VSM (storage) cerificated dictionary for my sql query filter.

Brs,

Richy

[rkiran · Accepted solution]

Can you try to specify the array_ip parameter from back to single quote : 

dest_array.ip = ‘${array_ip}’ 

To

dest_array.ip = '${array_ip}'

[Richy_TH]

Dear RKINRAN

it's working now thank you so much.

Brs,

Richy