Subscribe
Accepted Solution

Unable to query snap shot list WFA

Hi All

i am trying to create filter that could query snapshot list in the volume. but seem the result of query is emtry.

here is SQL query command:

 

 SELECT
snapshot.name
FROM
storage.snapshot,
storage.volume,
storage.array
WHERE
snapshot.volume_id = volume.id
AND volume.name = '${VolumeName}'
AND volume.array_id = array.id
AND array.ip = '${ArrayIP}' 

 

result:

 

Screen Shot 2558-01-06 at 11.39.35 AM.png

 

i have modified some component as below picture.

Screen Shot 2558-01-06 at 11.39.35 AM.png

 

Screen Shot 2558-01-06 at 11.40.41 AM.png

 

 

The list of snap shot on the storage.

 

netapp01> snap list -V EEC_swap_dr

Volume EEC_swap_dr

working...

 

  %/used       %/total  date          name

----------  ----------  ------------  --------

 40% (40%)    0% ( 0%)  Jan 06 10:32  EEC-Hourly_201501041100 

 55% (36%)    0% ( 0%)  Jan 06 02:44  nightly.0      

 64% (36%)    0% ( 0%)  Jan 06 02:42  nightly.1      

 70% (35%)    1% ( 0%)  Jan 04 20:00  hourly.0       

 74% (35%)    1% ( 0%)  Jan 04 16:00  hourly.1       

 78% (42%)    1% ( 0%)  Jan 03 22:26  clone_clone_EEC_swap_d.1 (busy,vclone)

 80% (27%)    1% ( 0%)  Jan 03 22:06  hourly.2       

 82% (35%)    1% ( 0%)  Jan 03 16:00  hourly.3       

 83% (35%)    1% ( 0%)  Jan 03 14:18  hourly.4       

 85% (35%)    1% ( 0%)  Dec 29 08:00  hourly.5

 

so anyone have any idea what do i miss to query the snap shot version.

 

Thank you,

Richy

 

Re: Unable to query snap shot list WFA

Is there any reason why for the certified Snapshot dictionary entry is cloned with the same fields?

Can you please set "Acquisition Enabled" field to true for the certified one and check if the data is acquired.

 

Regards

Abhi

Highlighted

Re: Unable to query snap shot list WFA

Dear Abhi

i just dont want to change any default setting to keep as refference.

so i did change it and use it as dictionary type in my filter the out put of query show as below.

 

Screen Shot 2558-01-06 at 12.07.06 PM.png

 

 

 

 

Screen Shot 2558-01-06 at 12.06.35 PM.png

 

 

please advise.

 

Thank you

 

Richy

Re: Unable to query snap shot list WFA

Hi All

i have solve the problem

with dictionary snapshot_1 with SQL quary command below. will be able to list the snap shot version of the volume.

 

SELECT
snapshot.name AS 'name'
FROM
storage.snapshot,
storage.volume,
storage.array
WHERE
snapshot.volume_id = volume.id
AND volume.name = '${VolumeName}'
AND volume.array_id = array.id
AND array.ip = '${ArrayIP}'

 

Thank you.

 

Richy