topic Re: Unable to query snap shot list WFA in Active IQ Unified Manager Discussions

Unable to query snap shot list WFA

Richy_TH — Thu, 05 Jun 2025 05:20:34 GMT

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

Re: Unable to query snap shot list WFA

abhit — Tue, 06 Jan 2015 04:59:24 GMT

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

Re: Unable to query snap shot list WFA

Richy_TH — Tue, 06 Jan 2015 05:08:56 GMT

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

Re: Unable to query snap shot list WFA

Richy_TH — Tue, 06 Jan 2015 05:46:04 GMT

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