<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Displaying additional information on User Input form. in Active IQ Unified Manager Discussions</title>
    <link>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Displaying-additional-information-on-User-Input-form/m-p/125863#M22610</link>
    <description>&lt;P&gt;Mike,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I think your idea of a non-operational command with an input variable for the aggregate will work. Adding&amp;nbsp;what Karale suggested will produce the behavior we are looking for.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;As for available capactiy, I came up with something similar.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;SELECT&lt;BR /&gt;&amp;nbsp; &amp;nbsp;round(aggregate.available_size_mb/1000) AS 'Available (GB)',&lt;BR /&gt;&amp;nbsp; &amp;nbsp;aggregate.name AS 'Name'&lt;BR /&gt;FROM&lt;BR /&gt;&amp;nbsp; &amp;nbsp;cm_storage.aggregate AS aggregate&lt;BR /&gt;JOIN&lt;BR /&gt;&amp;nbsp; &amp;nbsp;cm_storage.volume AS volume&lt;BR /&gt;&amp;nbsp; &amp;nbsp;ON volume.aggregate_id = aggregate.id&lt;BR /&gt;WHERE&lt;BR /&gt;&amp;nbsp; &amp;nbsp;volume.name = '${volume}'&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I played with committed capacity a little with a subquery. The concept is there but some tweaking will be needed to get something meaningful like overcomitted capacity in percentage.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;SELECT&lt;BR /&gt;&amp;nbsp; &amp;nbsp;round(sum(volume.size_mb/1000)) AS 'Committed (GB)'&lt;BR /&gt;FROM&lt;BR /&gt;&amp;nbsp; &amp;nbsp;cm_storage.volume AS volume&lt;BR /&gt;WHERE&lt;BR /&gt;&amp;nbsp; &amp;nbsp;volume.aggregate_id IN (SELECT&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;volume.aggregate_id AS 'Aggregate ID'&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;cm_storage.volume AS volume&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; WHERE&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;volume.name =&lt;SPAN&gt;'${volume}'&lt;/SPAN&gt;)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thank you,&lt;/P&gt;&lt;P&gt;Lawrence&lt;/P&gt;</description>
    <pubDate>Thu, 01 Dec 2016 13:16:39 GMT</pubDate>
    <dc:creator>lawrencg</dc:creator>
    <dc:date>2016-12-01T13:16:39Z</dc:date>
    <item>
      <title>Displaying additional information on User Input form.</title>
      <link>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Displaying-additional-information-on-User-Input-form/m-p/125814#M22586</link>
      <description>&lt;P&gt;Greetings,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;My colleagues and I are&amp;nbsp;discussing how to best display additional information to the WFA operator as they execute a workflow.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Our use case is around resizing a volume. We want to show the WFA operator how much aggregate capacity is available and/or how much the aggregate is overcommitted as they execute a Volume Resize workflow. We currently have a User Input of Type query and "Lock Values" to show the data we want.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Some parameters of our discussion:&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;You can still attempt to modify a query field that has "Lock Values" selected.&amp;nbsp;&lt;/LI&gt;&lt;LI&gt;We can&amp;nbsp;validate&amp;nbsp;overcommit/available capacity during execution but would like to warn the WFA operator at input time.&lt;/LI&gt;&lt;LI&gt;Are there&amp;nbsp;better ways&amp;nbsp;to show non-input values during user input?&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;Looking forward to hearing ideas. &lt;span class="lia-unicode-emoji" title=":slightly_smiling_face:"&gt;🙂&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Test_Vol_Resize.dar from WFA 4.0 attached for fun.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;-Lawrence&lt;/P&gt;</description>
      <pubDate>Wed, 04 Jun 2025 18:08:23 GMT</pubDate>
      <guid>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Displaying-additional-information-on-User-Input-form/m-p/125814#M22586</guid>
      <dc:creator>lawrencg</dc:creator>
      <dc:date>2025-06-04T18:08:23Z</dc:date>
    </item>
    <item>
      <title>Re: Displaying additional information on User Input form.</title>
      <link>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Displaying-additional-information-on-User-Input-form/m-p/125817#M22588</link>
      <description>&lt;P&gt;Lawrence,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp; You could use the No-Op command to define aggregate as a "User Input".&amp;nbsp; Then define the aggregate as a user input, you can then show the amount of space used, available or calculate the used percentage with the query.&amp;nbsp; Unfortunately the commited capacity is not in the wfa dictionary for aggregate, so that can not be displayed.&amp;nbsp; Something like the SQL query below (untested).&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Mike&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;SELECT&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; aggregate.name as 'Aggregate Name',&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; aggregate.available_size_mb as 'Available Size (MB)'&lt;BR /&gt;FROM&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; cm_storage.aggregate,&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; cm_storage.volume&lt;BR /&gt;WHERE&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; volume.aggregate = aggregate.id&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; AND volume.name = '${VolumeName}'&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 30 Nov 2016 19:22:56 GMT</pubDate>
      <guid>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Displaying-additional-information-on-User-Input-form/m-p/125817#M22588</guid>
      <dc:creator>geringer</dc:creator>
      <dc:date>2016-11-30T19:22:56Z</dc:date>
    </item>
    <item>
      <title>Re: Displaying additional information on User Input form.</title>
      <link>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Displaying-additional-information-on-User-Input-form/m-p/125852#M22604</link>
      <description>&lt;P&gt;You can use "user input" dependency section and make it read only by providing some value which will never satisfy the condition. This will make user input, non-input. Hope this helps.&lt;/P&gt;</description>
      <pubDate>Thu, 01 Dec 2016 02:54:54 GMT</pubDate>
      <guid>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Displaying-additional-information-on-User-Input-form/m-p/125852#M22604</guid>
      <dc:creator>karale</dc:creator>
      <dc:date>2016-12-01T02:54:54Z</dc:date>
    </item>
    <item>
      <title>Re: Displaying additional information on User Input form.</title>
      <link>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Displaying-additional-information-on-User-Input-form/m-p/125863#M22610</link>
      <description>&lt;P&gt;Mike,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I think your idea of a non-operational command with an input variable for the aggregate will work. Adding&amp;nbsp;what Karale suggested will produce the behavior we are looking for.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;As for available capactiy, I came up with something similar.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;SELECT&lt;BR /&gt;&amp;nbsp; &amp;nbsp;round(aggregate.available_size_mb/1000) AS 'Available (GB)',&lt;BR /&gt;&amp;nbsp; &amp;nbsp;aggregate.name AS 'Name'&lt;BR /&gt;FROM&lt;BR /&gt;&amp;nbsp; &amp;nbsp;cm_storage.aggregate AS aggregate&lt;BR /&gt;JOIN&lt;BR /&gt;&amp;nbsp; &amp;nbsp;cm_storage.volume AS volume&lt;BR /&gt;&amp;nbsp; &amp;nbsp;ON volume.aggregate_id = aggregate.id&lt;BR /&gt;WHERE&lt;BR /&gt;&amp;nbsp; &amp;nbsp;volume.name = '${volume}'&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I played with committed capacity a little with a subquery. The concept is there but some tweaking will be needed to get something meaningful like overcomitted capacity in percentage.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;SELECT&lt;BR /&gt;&amp;nbsp; &amp;nbsp;round(sum(volume.size_mb/1000)) AS 'Committed (GB)'&lt;BR /&gt;FROM&lt;BR /&gt;&amp;nbsp; &amp;nbsp;cm_storage.volume AS volume&lt;BR /&gt;WHERE&lt;BR /&gt;&amp;nbsp; &amp;nbsp;volume.aggregate_id IN (SELECT&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;volume.aggregate_id AS 'Aggregate ID'&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;cm_storage.volume AS volume&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; WHERE&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;volume.name =&lt;SPAN&gt;'${volume}'&lt;/SPAN&gt;)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thank you,&lt;/P&gt;&lt;P&gt;Lawrence&lt;/P&gt;</description>
      <pubDate>Thu, 01 Dec 2016 13:16:39 GMT</pubDate>
      <guid>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Displaying-additional-information-on-User-Input-form/m-p/125863#M22610</guid>
      <dc:creator>lawrencg</dc:creator>
      <dc:date>2016-12-01T13:16:39Z</dc:date>
    </item>
    <item>
      <title>Re: Displaying additional information on User Input form.</title>
      <link>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Displaying-additional-information-on-User-Input-form/m-p/125864#M22611</link>
      <description>&lt;P&gt;Karale,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Creating a Dependency that is never satisfied creates the behavior we are looking for. I tested by&amp;nbsp;making the aggregate input variable dependent on "Volume" with the value of "no_volume". It works unless we create a volume on one of the clusters named "no_volume" and someone wants to resize it. At that point, if we use Mike's suggestion of a No-op command in the workflow, even if the user modify the field we intend only as a display field, it will not have an affect on the execution.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Problem solved.&amp;nbsp;&lt;img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://community.netapp.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Kind regards,&lt;/P&gt;&lt;P&gt;Lawrence&lt;/P&gt;</description>
      <pubDate>Thu, 01 Dec 2016 13:26:27 GMT</pubDate>
      <guid>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Displaying-additional-information-on-User-Input-form/m-p/125864#M22611</guid>
      <dc:creator>lawrencg</dc:creator>
      <dc:date>2016-12-01T13:26:27Z</dc:date>
    </item>
  </channel>
</rss>

