If you missed the pre-registration for NetApp MS Azure AD B2C, the new login prompt will offer the option to register. Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

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 

 

1 ACCEPTED SOLUTION

rkiran

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

rkiran

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

Richy_TH

Dear RKINRAN

it's working now thank you so much.

 

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.

 

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

Richy_TH

Dear All

it's for 7-mode Filer.

 

Brs,

Richy

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public