Subscribe
Accepted Solution

filter SQL Query for VSM destination volume

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

Dear All

it's for 7-mode Filer.

 

Brs,

Richy

Re: filter SQL Query for VSM destination volume

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.

 

Screen Shot 2558-01-26 at 12.11.30 AM.png

 

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

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}'

 

Re: filter SQL Query for VSM destination volume

Dear RKINRAN

it's working now thank you so much.

 

Brs,

Richy