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

Short-list the available ENUM values based on the selection of an ENUM value in previous steps

mmodi

Hi Guys,

I was wondering if there is a way to short-list the available ENUM values based on the selection of an ENUM value in previous steps ?

Note that this is just simple logic, not relying on the cm_storage database or any other technical components....

Example : List Available Protocols based on the platform type which then further allows selecting the protocol to be storage as the variable.

======== Variable Name : Platform, Type : ENUM


  • File_Storage_Windows
  • File_Storage_UNIX
  • File_Storage_Virtualization
  • Block_Storage

======== Variable Name : PrimaryProtocol, Type : ENUM

  • cifs
  • nfs
  • iscsi
  • fcp

Thanks

Modi

1 ACCEPTED SOLUTION

mmodi

Thanks Michael,

Is there anything you cannot answer 🙂

======= Meanwhile, I had to replace "EQUALS" with "=" to make the logic work :

select

    'cifs' as protocol

from

    dual

WHERE

    '${Platform}' = "File_Storage_Windows"

union

select

    'nfs' as protocol

from

    dual

WHERE

    '${Platform}' = "File_Storage_UNIX"

    OR '${Platform}' = "File_Storage_ESX_Virtualization"

union

select

    'iscsi' as protocol

from

    dual

WHERE

    '${Platform}' = "Block_Storage"

union

select

    'fcp' as protocol

from

    dual

WHERE

    '${Platform}' = "Block_Storage"

View solution in original post

2 REPLIES 2

mgoddard

Hi Modi,

You could use an SQL Query to generate a query result based on the input of another variable, to make it a dynamic enum of sorts. You'll need to select from a table but there is an in-built temporary table in MySQL and Oracle for this purpose called 'dual'.

Here's an example that would enable cifs/iscsi for *Windows services, iscsi/nfs/fcp for *ESX and iscsi/nfs for *nix (Linux/Unix). You could use equals if you wand an exact match. Just add another OR to the line to create more services that are enabled for each protocol.

select 'cifs' as protocol from dual WHERE '${service}' LIKE "%Windows" union

select 'iscsi' as protocol from dual WHERE '${service}' LIKE "%Windows" OR '${service}' LIKE "%ESX" OR '${service}' LIKE "%nix" union

select 'nfs' as protocol from dual WHERE '${service}' LIKE "%ESX" OR '${service}' LIKE "%nix" union

select 'fcp' as protocol from dual WHERE '${service}' LIKE "%ESX"

Or for the specific example above:

select 'cifs' as protocol from dual WHERE '${Platform}' EQUALS "File_Storage_Windows" union

select 'nfs' as protocol from dual WHERE '${Platform}' EQUALS "File_Storage_UNIX" OR '${Platform}' EQUALS "File_Storage_Virtualization" union

select 'iscsi' as protocol from dual WHERE '${Platform}' EQUALS "Block_Storage" union

select 'fcp' as protocol from dual WHERE '${Platform}' EQUALS "Block_Storage"

It may be better to use technology-specific names, as ESX virtualization would present data stores differently to Hyper-V virtualization for instance.

Kind Regards,

Michael Goddard.

mmodi

Thanks Michael,

Is there anything you cannot answer 🙂

======= Meanwhile, I had to replace "EQUALS" with "=" to make the logic work :

select

    'cifs' as protocol

from

    dual

WHERE

    '${Platform}' = "File_Storage_Windows"

union

select

    'nfs' as protocol

from

    dual

WHERE

    '${Platform}' = "File_Storage_UNIX"

    OR '${Platform}' = "File_Storage_ESX_Virtualization"

union

select

    'iscsi' as protocol

from

    dual

WHERE

    '${Platform}' = "Block_Storage"

union

select

    'fcp' as protocol

from

    dual

WHERE

    '${Platform}' = "Block_Storage"

View solution in original post

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