topic Re: filter SQL Query for VSM destination volume in Active IQ Unified Manager Discussions

filter SQL Query for VSM destination volume

Richy_TH — Thu, 05 Jun 2025 05:13:55 GMT

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

Re: filter SQL Query for VSM destination volume

Richy_TH — Sun, 25 Jan 2015 14:59:55 GMT

Dear All

it's for 7-mode Filer.

Brs,

Richy

Re: filter SQL Query for VSM destination volume

Richy_TH — Sun, 25 Jan 2015 17:15:48 GMT

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

Re: filter SQL Query for VSM destination volume

rkiran — Tue, 27 Jan 2015 08:44:16 GMT

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

dest_array.ip = ‘${array_ip}’

dest_array.ip = '${array_ip}'

Re: filter SQL Query for VSM destination volume

Richy_TH — Tue, 27 Jan 2015 18:26:09 GMT

Dear RKINRAN

it's working now thank you so much.

Brs,

Richy