Active IQ Unified Manager Discussions

filter SQL Query for VSM destination volume

Richy_TH
3,548 Views

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 

 

1 ACCEPTED SOLUTION

rkiran
3,484 Views

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

 

View solution in original post

4 REPLIES 4

Richy_TH
3,536 Views

Dear All

it's for 7-mode Filer.

 

Brs,

Richy

Richy_TH
3,527 Views

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

rkiran
3,485 Views

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
3,469 Views

Dear RKINRAN

it's working now thank you so much.

 

Brs,

Richy

Public