Effective December 3, NetApp adopts Microsoft’s Business-to-Customer (B2C) identity management to simplify and provide secure access to NetApp resources.
For accounts that did not pre-register (prior to Dec 3), access to your NetApp data may take up to 1 hour as your legacy NSS ID is synchronized to the new B2C identity.
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

SQL Queries for User Input

yarmas

Great Tech Team Deep Dive this morning, thanks.

I would like to know more about the schema that we can query for creating pull-downs in the User Input section.

For example, to get a list of aggregate names for a given controller we can use:

SELECT

    aggr.name

FROM

    storage.aggregate AS aggr, storage.array AS array

WHERE

    aggr.array_id = array.id AND (array.ip = '${controllerName}' OR array.name = '${controllerName}')

But it would help to know more about the schema so we can create more precise SQL statements.

Thanks.

-tom

1 ACCEPTED SOLUTION

yaronh

Hi Tom,

On the top left menu bar, select "Help" and then "Reference Manual".

An on-the-fly, automatically generated reference manual would  be created, where you can navigate the various parts.

On the top left you can find "cache tables" entity, which would detail all the tables in the cache and their structure.

Would be worth noting that the reference manual is generated "Here and now". So if you created workflows, finders and

even new cache tables - They would appear there and would be nicely documented if you took the time to do so 🙂

Hope that helps,

Yaron Haimsohn

WFA team

View solution in original post

3 REPLIES 3

yaronh

Hi Tom,

On the top left menu bar, select "Help" and then "Reference Manual".

An on-the-fly, automatically generated reference manual would  be created, where you can navigate the various parts.

On the top left you can find "cache tables" entity, which would detail all the tables in the cache and their structure.

Would be worth noting that the reference manual is generated "Here and now". So if you created workflows, finders and

even new cache tables - They would appear there and would be nicely documented if you took the time to do so 🙂

Hope that helps,

Yaron Haimsohn

WFA team

View solution in original post

yarmas

Thanks, that helps a lot. The SQL Examples are very helpful, although it looks like you can only have one item in the select clause when using the SQL for user input queries.

-tom

hill

Hi Tom,

For other examples, you can check out the Example WFA workflows.  Many of them have different user input queries... as well as staggered inputs (select Array, then Aggr, then volume then qtree, etc).

Currently with WFA 1.1.1, you can only have one select at a time.... or an SQL "concat" that joins multiple elements... but would then need to be split out with a function when used in the workflow.  In WFA 2.0, it will be possible to identify the "Main" element... and then additional supporting inputs that can help guide a WFA "Operator" to the best resource based on what WFA can see of the environment.

Hope this helps,

-Kevin

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