UCSD Create VM Details CSV file

Version 6
    Task Name


    Cycle through selected VM's and generate their VM details and write the details to a file in CSV format and then e-mail the file

    Description

     

    Prerequisites
    1. Tested on 5.4
    CategoryWorkflow
    ComponentsvSphere 5.x
    User Inputse-mail address
    Outpute-mail with counter

    Instructions for Regular Workflow Use:

    1. Download the attached .ZIP file below to your computer. *Remember the location of the saved file on your computer.
    2. Unzip the file on your computer. Should end up with a .WFD file.
    3. Log in to UCS Director as a user that has "system-admin" privileges.
    4. Navigate to "Policies-->Orchestration" and click on "Import".
    5. Click "Browse" and navigate to the location on your computer where the .WFDX file resides. Choose the .WFDX file and click "Open".
    6. Click "Upload" and then "OK" once the file upload is completed. Then click "Next".
    7. Click the "Select" button next to "Import Workflows". Click the "Check All" button to check all checkboxes and then the "Select" button.
    8. Click "Submit".
    9. A new folder should appear in "Policies-->Orchestration" that contains the imported workflow. You will now need to update the included tasks with information about the specific environment

     

    The workflow:

     

    workflow_1662.png

     

    Email Example:

     

    Screen Shot 2015-11-16 at 6.57.09 AM.png

     

    Run Time:

     

    Screen Shot 2015-11-16 at 6.25.48 AM.png

     

    The following workflow items need to be changed in the Environment:

     

    Screen Shot 2015-11-16 at 7.40.17 AM.png

     

    C0 through C10 are the column Headings for the CSV file.  These can be changed as well.

     

     

    The file header is written here and the input comes from the Admin Input Value above:

     

    Screen Shot 2015-11-16 at 7.44.59 AM.png

     

    The mapping:

     

    Screen Shot 2015-11-16 at 7.44.51 AM.png

     

     

    The VM details are mapped and written to file here:

     

    Screen Shot 2015-11-16 at 7.43.30 AM.png

     

    Screen Shot 2015-11-16 at 7.43.59 AM.png

     

    The workflow also send another e-mail with the attachment (CSV file) .