Unable to query snap shot list WFA

[Richy_TH]

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:

i have modified some component as below picture.

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

[abhit]

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

[Richy_TH]

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.

please advise.

Thank you

Richy

[Richy_TH · Accepted solution]

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