topic Re: How to get list of snapshots in Active IQ Unified Manager Discussions

How to get list of snapshots

slair — Thu, 05 Jun 2025 06:00:49 GMT

Hello,

I am working to create a workflow that does a flexclone of a volume/snapshot. I need to be able to present the user a list of snapshots on a volume and then clone the volume based on the user selected snapshot. I tried creating a user input variable of type Query, and used the following simple query for a test:

SELECT name

FROM storage.snapshot

When i click on test, i do not get any results at all. How can i query for a list of snapshots on a volume?

Thanks

Sean

Re: How to get list of snapshots

goodrum — Tue, 11 Jun 2013 14:26:47 GMT

You need to enable Snapshot caching. Open the WFA web page and go to Tools > WFA Configuration. Go the the 'Other' tab and remove the 'storage.snapshot' entry.

Jeremy Goodrum, NetApp

The Pirate

Twitter: @virtpirate

Blog: www.virtpirate.com

Re: How to get list of snapshots

slair — Tue, 11 Jun 2013 15:26:21 GMT

That was it, thanks! Here is what i used for the SQL Query for the User Input:

SELECT snapshot.name

FROM storage.snapshot, storage.volume

WHERE

volume_id = volume.id

AND volume.name = ${source_volume}

Re: How to get list of snapshots

rramirez — Wed, 11 Sep 2013 16:40:11 GMT

Hi Jeremy,

Where can I find this option in version 2.1RC1?

Thanks!

Re: How to get list of snapshots

goodrum — Wed, 11 Sep 2013 17:04:38 GMT

Ok, it took me a little to figure it out because I haven't looked since the upgrade. Go to the Dictionary page and look at the 'Acquisition Enabled' column (should be the fifth column). Filter on False to see the Dictionary items that are not cached. Right Click on the Dictionary that you want to enable and select 'Enable Acquisition'

Jeremy Goodrum, NetApp

The Pirate

Twitter: @virtpirate

Blog: www.virtpirate.com

Re: How to get list of snapshots

rramirez — Wed, 11 Sep 2013 19:58:57 GMT

Worked like a charm.

Thanks!