cancel
Showing results for 
Search instead for 
Did you mean: 
cancel

UCSD Create your own DB entries / Report / Multi Column LOV

1524
Views
1
Helpful
2
Comments
Task NameUCSD Create your own DB Entries / Report / Mulit Column LOV
Description
  1. UCSD Create your own DB Entries / Report / Mulit Column LOV
Prerequisites
  1. Tested on 5.4
CategoryWorkflow
ComponentsvSphere 5.x
User Inputs

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 .WFD file resides. Choose the .WFD 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.

Inspiration came from Stanly Abraham. Thank you very much.

UCSD Create your own DB Entries / Report / Mulit Column LOV



The possible workflow input for the workflow create from a custom report:


Screen Shot 2015-11-10 at 10.36.30 AM.png


After the selection:


Screen Shot 2015-11-10 at 9.39.34 AM.png


The run with the hidden management column:


Screen Shot 2015-11-10 at 9.40.06 AM.png


The workflow result:


Screen Shot 2015-11-10 at 9.45.46 AM.png


Different run of this workflow:


Screen Shot 2015-11-10 at 9.31.16 AM.png



The workflow for illustration:


Screen Shot 2015-11-10 at 9.28.16 AM.png


The e-mail set up with the report variable:


Screen Shot 2015-11-10 at 9.28.37 AM.png


The global variable set up in the workflow:


Screen Shot 2015-11-10 at 9.32.00 AM.png


Report_1 is the custom report variable!



Screen Shot 2015-11-10 at 9.32.12 AM.png



The script module Tabular Report


Screen Shot 2015-11-10 at 9.32.46 AM.png


The script module Tabular Report Column definitions:


Note column D is hidden and is the result from the selection process!


Screen Shot 2015-11-10 at 9.32.57 AM.png



The script that gets generated from the creation of the columns:


Make sure your code is between the start and end of the "your implementation"!

If not you will re-create it!

Screen Shot 2015-11-10 at 9.35.29 AM.png


The script for this example.


This could be read in from CSV file or some SQL statements as well.

Screen Shot 2015-11-10 at 9.38.23 AM.png



Note for export of workflow:


Make sure the script module is checked!


Screen Shot 2015-11-10 at 10.01.48 AM.png



Comments
Community Member

I like the idea of using the tabular report, but is there a possibility to put all information of the report into the mail?

The resulting mail now only reports Steel or Aluminium truck. Is it possible to also add the brand an colour in the mail?

Cisco Employee

only way I have seen this have a filed that is hidden and looks like this

Ford,Aluminium,red  and you make the the main filed.

Content for Community-Ad
This widget could not be displayed.