Active IQ Unified Manager Discussions

SQL Query Inside a Table User Input

coreywanless
3,139 Views

Running WFA 3.1P1

 

I need help with a possible syntax issue.  If there are existing canned workflows I can reference that would be good as well.

 

I created a Table User Input from the variable name of "Volumes" with 4 columns. The first three Columns need to be SQL queries. 

 

Columns:

  1. Cluster - SQL Query
  2. SVM - SQL Query
  3. Volume - SQL Query
  4. LUN Count to Add - Number

From the SVM SQL Query, I'm trying to find the syntax on how to call the Cluster Variable in the table.  Any Suggestions?  Below is the query I'm running from the SVM column.

 

select vserver.name from cm_storage.vserver join cm_storage.cluster on cluster.id = vserver.cluster_id where cluster.name = '${Volumes:Cluster}'

 

Maybe this is something that is not available.

 

1 ACCEPTED SOLUTION

sinhaa
3,127 Views

Corey,

 

You may want to look at this link: http://community.netapp.com/t5/OnCommand-Storage-Management-Software-Discussions/User-Inputs-Query-to-populate-table-predefined-choices/m-p/113285

 

sinhaa

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

View solution in original post

2 REPLIES 2

sinhaa
3,128 Views

Corey,

 

You may want to look at this link: http://community.netapp.com/t5/OnCommand-Storage-Management-Software-Discussions/User-Inputs-Query-to-populate-table-predefined-choices/m-p/113285

 

sinhaa

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

coreywanless
3,115 Views

Yep, that was it. Thanks!

Public