2 Replies Latest reply: Aug 18, 2014 11:15 AM by Ray Olander RSS

    My Nimble Script Generator Tool

    Ray Olander Wayfarer
    Visibility: Open to anyone

      NOTE: This tool has been updated to version 5.13 and can be found here: My Excel Planner and Script Generator Workbooks for Nimble Storage Arrays



      Let's say you purchase a new Nimble array and you determine you need to create and configure like 150 volumes, each of which will need to be associated with a volume collection, which in turn needs to be defined with a schedule and credentials and so on. And of course, you'll need to define initiator groups, possibly some performance profiles, and maybe even set the array from fresh out of the box. I know all that can be done with the GUI, but who really wants to do that? Before there was a way to interface with the array via powershell (which I have yet to get to try), the way I came up with to "automate" generating the scripts I needed was to use Excel.


      The Excel workbook I've attached is a much refined version of what I initially built to deploy our first Nimblestorage array. That sheet worked so well that I just had to see how far I could take it. Little by little in my "free time" I've added capabilities until it has finally reached what I consider to be presentable to others. Once I was ready to let people see it, I showed it to a select few of the Nimblestorage team and I have received very positive feedback, so I am hoping it will be useful for others as well. This version is for 1.4.x code. I have a 2.x code version in the works, but it is not ready quite yet. I will release it as soon as I can.


      This can be used as a planning tool, which effectively results in generating documentation of the array configuration. However, the real value is that it generates ALL the BUILD commands associated with your inputs AND it generates all the DELETE commands to undo what you configured as well (since there's no "factory reset" option on the array). I create the code locally on each planning page (in case you just need a quick command) as well as having an "all-in-one" sheet for both create and delete code where I scrape the code from the entire workbook and organize it (for the full copy/paste array build).


      The first sheet in the workbook has a lot of information about general items as well as about specific pages. Please be sure to read through that entirely before working with the sheet, I think you'll find that it helps a lot. The workbook is organized into sections and in steps. Complete the sheets in their numbered order, each sheet in the workbook has information that is used by drop-down boxes in later sheets. For example, when you fill in volume names in the planning sheet, those names automatically appear in the drop-down boxes of higher numbered sheets such as the volume collection sheet. For data that is a little more static, or is not Nimblestorage-based (such as naming conventions or volume size standards you may want to define), there is a TABLES tab that you update in section one. Those too will automatically appear in drop-downs elsewhere. When you finish entering data on the last page, go to the "FINAL CREATE CODE" sheet and click the GENERATE "CREATE" CODE button and all the code will appear.


      The code for this tool is taken from the Nimblestorage CLI guide, which significantly lacks clarity and examples. While I have had the opportunity to test some of the code generated by this sheet, I have not been able to test ALL the code. If only there was an emulator I could get access to!


      Feel free to give feedback by posting a comment on my blog http://virtuallyuseful.wordpress.com, emailing me at virtuallyuseful@gmail.com or sending me a tweet at @VirtuallyUseful


      Message was edited by: Ray Olander Discovered the formulas for GB/TB calculations were incorrect on the PARSE VOLUME OUTPUT sheet. Fixed with v5.12.

        • Re: My Nimble Script Generator Tool
          Todd Moore Adventurer

          Very interesting, and thanks for your contribution. I'd be happy to work with you in testing the things you haven't been able to do. Let me know if you want to try and connect.

            • Re: My Nimble Script Generator Tool
              Ray Olander Wayfarer

              Hi Todd,


              I'd be very interested to hear your experiences with the sheet! The main things I haven't use the scripts for are creating a replication partner, adding a volume collection schedule, creating a protection template, and most of the delete commands. I just didn't have the opportunity to do a lot of actual testing. Ideally, I'd like to see a new array completely built using every sheet in the tool and then have everything removed as well. Shouldn't take long to try really since the scripts are all generated, I unfortunately just don't have a new array hanging around waiting for me to test against it.