| Task Name | Report example on how to get the APIC application Tenant Profile Name. |
| Description | |
| Prerequisites | Tested on UCSD 6.0.0.0 |
| Category | Workflow |
| Components | vSphere 5.x |
| User Inputs |
Instructions for Regular Workflow Use:
- Download the attached .ZIP file below to your computer. *Remember the location of the saved file on your computer.
- Unzip the file on your computer. Should end up with a .WFD file.
- Log in to UCS Director as a user that has "system-admin" privileges.
- Navigate to "Policies-->Orchestration" and click on "Import".
- Click "Browse" and navigate to the location on your computer where the .WFD file resides. Choose the .WFD file and click "Open".
- Click "Upload" and then "OK" once the file upload is completed. Then click "Next".
- Click the "Select" button next to "Import Workflows". Click the "Check All" button to check all checkboxes and then the "Select" button.
- Click "Submit".
- 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.
Workflow:
The custom task as well as the Cloupia script are included.
Input:
The Log:
Service Request ID: 361
Workflow Inputs:
- outa1
- outa2
- APIC_Tenant
- Email Address
Jan 19, 2017 15:55:00 UTC Request submitted
Jan 19, 2017 15:55:05 UTC Executing workflow item number 1
Jan 19, 2017 15:55:05 UTC Completed workflow item number 1, with status Completed
Jan 19, 2017 15:55:11 UTC Executing workflow item number 2
Jan 19, 2017 15:55:11 UTC Trigger context executeWorkFlowStep called
Jan 19, 2017 15:55:12 UTC Executing custom action ReportAPICTenantProfiles (custom_APICTenantApplicationProfile)
Jan 19, 2017 15:55:12 UTC Executing custom action ReportAPICTenantProfiles (custom_APICTenantApplicationProfile)
Jan 19, 2017 15:55:12 UTC Executing custom script for APICTenantApplicationProfile
Jan 19, 2017 15:55:12 UTC Input : OracleAPIC@infra
Jan 19, 2017 15:55:12 UTC Input 0 : OracleAPIC
Jan 19, 2017 15:55:12 UTC Input 1 : infra
Jan 19, 2017 15:55:12 UTC numRowsFound : 1
Jan 19, 2017 15:55:12 UTC DN: uni/tn-infra/ap-access
Jan 19, 2017 15:55:12 UTC Application Profile Name: access
Jan 19, 2017 15:55:12 UTC Tenant: infra
Jan 19, 2017 15:55:12 UTC Description:
Jan 19, 2017 15:55:12 UTC QOS Class: unspecified
Jan 19, 2017 15:55:12 UTC DN 0: uni
Jan 19, 2017 15:55:12 UTC DN 1: tn-infra
Jan 19, 2017 15:55:12 UTC Dn 2: ap-access
Jan 19, 2017 15:55:12 UTC Processing output: a0
Jan 19, 2017 15:55:12 UTC Processing output: a1
Jan 19, 2017 15:55:12 UTC Processing output: a2
Jan 19, 2017 15:55:12 UTC Processing output: a3
Jan 19, 2017 15:55:12 UTC Processing output: a4
Jan 19, 2017 15:55:12 UTC Processing output: dn0
Jan 19, 2017 15:55:12 UTC Processing output: dn1
Jan 19, 2017 15:55:13 UTC Processing output: dn2
Jan 19, 2017 15:55:13 UTC Task #2 (ReportAPICTenantProfiles (custom_APICTenantApplicationProfile)) completed successfully in 1 seconds
Jan 19, 2017 15:55:13 UTC Input/Output values for Task #2 (ReportAPICTenantProfiles (custom_APICTenantApplicationProfile)):
Jan 19, 2017 15:55:13 UTC [Mapped Input: APICTenant = OracleAPIC@infra]
Jan 19, 2017 15:55:13 UTC [Output: a0 = uni/tn-infra/ap-access]
Jan 19, 2017 15:55:13 UTC [Output: a1 = access]
Jan 19, 2017 15:55:13 UTC [Output: a2 = infra]
Jan 19, 2017 15:55:13 UTC [Output: a3 = ]
Jan 19, 2017 15:55:13 UTC [Output: a4 = unspecified]
Jan 19, 2017 15:55:13 UTC [Output: dn0 = uni]
Jan 19, 2017 15:55:13 UTC [Output: dn1 = tn-infra]
Jan 19, 2017 15:55:13 UTC [Output: dn2 = ap-access]
Jan 19, 2017 15:55:13 UTC Completed workflow item number 2, with status Completed
Jan 19, 2017 15:55:14 UTC Executing workflow item number 3
Jan 19, 2017 15:55:14 UTC Trigger context executeWorkFlowStep called
Jan 19, 2017 15:55:14 UTC Executing custom action ReportAPICTenantProfiles (ExecuteCloupiaScript)
Jan 19, 2017 15:55:14 UTC Executing custom action ReportAPICTenantProfiles (ExecuteCloupiaScript)
Jan 19, 2017 15:55:15 UTC Executing cloupia script: ReportsAPICTenantProfiles
Jan 19, 2017 15:55:15 UTC AT : OracleAPIC@infra
Jan 19, 2017 15:55:15 UTC 0 : OracleAPIC
Jan 19, 2017 15:55:15 UTC 1 : infra
Jan 19, 2017 15:55:15 UTC numRowsFound : 1
Jan 19, 2017 15:55:15 UTC report: com.cloupia.lib.util.managedreports.TableView@14bd62fc
Jan 19, 2017 15:55:15 UTC DN: uni/tn-infra/ap-access
Jan 19, 2017 15:55:15 UTC Profile02: access
Jan 19, 2017 15:55:15 UTC Tenant: infra
Jan 19, 2017 15:55:15 UTC Description:
Jan 19, 2017 15:55:15 UTC QOS Class: unspecified
Jan 19, 2017 15:55:15 UTC DN 0: uni
Jan 19, 2017 15:55:15 UTC DN 1: tn-infra
Jan 19, 2017 15:55:15 UTC Dn 2: ap-access
Jan 19, 2017 15:55:15 UTC Sending email
Jan 19, 2017 15:55:15 UTC Completed cloupia script ReportsAPICTenantProfiles
Jan 19, 2017 15:55:15 UTC Task #3 (ReportAPICTenantProfiles (ExecuteCloupiaScript)) completed successfully in 0 seconds
Jan 19, 2017 15:55:15 UTC Input/Output values for Task #3 (ReportAPICTenantProfiles (ExecuteCloupiaScript)):
Jan 19, 2017 15:55:15 UTC [Local Input: Label = ReportsAPICTenantProfiles]
Jan 19, 2017 15:55:15 UTC [Local Input: Script = importPackage(java.util); importPackage(java.lang); importPackage(java.io); importPackage(com.cloupia.model.cEvent.notify); importPackage(com.cloupia.model.cIM); importPackage(com.cloupia.lib.util.mail); importPackage(com.cloupia.fw.objstore); importPackage(com.cloupia.lib.util.managedreports); importPackage(com.cloupia.service.cIM.inframgr.profiles); importPackage(com.cloupia.service.cIM.inframgr); function getMailSettings() { return ObjStoreHelper.getStore((new MailSettings()).getClass()).getSingleton(); } function getReport(reportContext, reportName) { var report = null; try { report = ctxt.getAPI().getConfigTableReport(reportContext, reportName); } catch(e) { } if (report == null) { return ctxt.getAPI().getTabularReport(reportName, reportContext); } else { var source = report.getSourceReport(); return ctxt.getAPI().getTabularReport(source, reportContext); } } function getReportView(reportContext, reportName) { var report = getReport(reportContext, reportName); if (report == null) { logger.addError('No such report exists for the specified context '+reportName); return null; } return new TableView(report); } // Assume the To Email Addres is in the input variable 'Email Address' var toEmail = [ ctxt.getInput('Email Address') ]; var message = new EmailMessageRequest(); message.setToAddrs(toEmail); message.setSubject('APIC Tenant Profile Report'); message.setFromAddress('no-reply@cisco.com'); var buffer = new StringWriter(); var printer = new PrintWriter(buffer); // Formatter exists in multiple packages, so it needs fully qualified name var formatter = new com.cloupia.lib.util.managedreports.Formatter(new File('.'), printer); var AT = ctxt.getInput('APIC_Tenant'); logger.addInfo('AT : ' + AT); var x = AT.split('@'); logger.addInfo('0 : ' + x[0]); logger.addInfo('1 : ' + x[1]); var reportName='apic.tenant.appln.profile.report.config'; var repContext = util.createContextByType( '90160','','accountName=='' + x[0] +'' && name=='' + x[1] +'''); var report = getReportView(repContext, reportName); var i=0; var numRowsFound = report.rowCount(); logger.addInfo('numRowsFound : ' + numRowsFound); logger.addInfo('report: ' + report); var a0 = report.getColumnValue(0, 'DN'); logger.addInfo('DN: ' + a0); //var a1 = report.getColumnValue(0, 'Application Profile Name'); var a1 = report.getColumnValue(0, 'Name'); logger.addInfo('Profile02: ' + a1); var a2 = report.getColumnValue(0, 'Tenant '); logger.addInfo('Tenant: ' + a2); var a3 = report.getColumnValue(0, 'Description'); logger.addInfo('Description: ' + a3); var a4 = report.getColumnValue(0, 'QoS Class'); logger.addInfo('QOS Class: ' + a4); var sp = a0.split('/'); logger.addInfo('DN 0: ' + sp[0]); logger.addInfo('DN 1: ' + sp[1]); logger.addInfo('Dn 2: ' + sp[2]); ctxt.updateInput('outa1', sp[2]); formatter.printTable(report); printer.close(); var body = '<head><style type='text/css'>'; // Specify CSS for the report body = body + 'table { font-family: Verdana, Geneva, sans-serif; font-size: 12px; border: thin solid #039; border-spacing: 0; background: #ffffff; } '; body = body + ' th { background-color: #6699FF; color: white; font-family: Verdana, Geneva, sans-serif; font-size: 10px; font-weight: bold; border-color: #CCF; border-style: solid; border-width: 1px 1px 0 0; margin: 0; padding: 5px; } '; body = body + ' td { font-family: Verdana, Geneva, sans-serif; font-size: 10px; border-color: #CCF; border-style: solid; border-width: 1px 1px 0 0; margin: 0; padding: 5px; background: #ffffff; }'; body = body + '</style></head>'; body = body+ '<body><h1>VDC 1 Report</h1><br>' + buffer.toString(); message.setMessageBody(body); logger.addInfo('Sending email'); // Now, send the report via email. First parameter is just a label used in the // internal logs MailManager.sendEmail('VDC approver report', getMailSettings(), message); ]
Jan 19, 2017 15:55:15 UTC [Local Input: Undo Script = ]
Jan 19, 2017 15:55:15 UTC Completed workflow item number 3, with status Completed
Jan 19, 2017 15:55:17 UTC Executing workflow item number 4
Jan 19, 2017 15:55:17 UTC Trigger context executeWorkFlowStep called
Jan 19, 2017 15:55:17 UTC Executing custom action ReportAPICTenantProfiles (Send Email)
Jan 19, 2017 15:55:17 UTC Executing custom action ReportAPICTenantProfiles (Send Email)
Jan 19, 2017 15:55:18 UTC Sending email to ogelbric@cisco.com, with Subject APIC Tenant Profle
Jan 19, 2017 15:55:18 UTC Task #4 (ReportAPICTenantProfiles (Send Email)) completed successfully in 0 seconds
Jan 19, 2017 15:55:18 UTC Input/Output values for Task #4 (ReportAPICTenantProfiles (Send Email)):
Jan 19, 2017 15:55:18 UTC [Local Input: E-mail Addresses = ogelbric@cisco.com]
Jan 19, 2017 15:55:18 UTC [Local Input: Subject = APIC Tenant Profle]
Jan 19, 2017 15:55:18 UTC [Template Input:Body = ${outa1}]
Jan 19, 2017 15:55:18 UTC [Resolved Template Input: Body = ap-access]
Jan 19, 2017 15:55:18 UTC [Local Input: Body = ap-access]
Jan 19, 2017 15:55:18 UTC [Output: EMAIL_ADDRESSES = ogelbric@cisco.com]
Jan 19, 2017 15:55:18 UTC Completed workflow item number 4, with status Completed
Jan 19, 2017 15:55:23 UTC Executing workflow item number 5
Jan 19, 2017 15:55:23 UTC Completed workflow item number 5, with status Completed
The Custom Task:
importPackage(java.util);
importPackage(java.lang);
importPackage(java.io);
importPackage(com.cloupia.model.cEvent.notify);
importPackage(com.cloupia.model.cIM);
importPackage(com.cloupia.lib.util.mail);
importPackage(com.cloupia.fw.objstore);
importPackage(com.cloupia.lib.util.managedreports);
importPackage(com.cloupia.service.cIM.inframgr.profiles);
importPackage(com.cloupia.service.cIM.inframgr);
function getReport(reportContext, reportName)
{
var report = null;
try
{
report = ctxt.getAPI().getConfigTableReport(reportContext, reportName);
} catch(e)
{
}
if (report == null)
{
return ctxt.getAPI().getTabularReport(reportName, reportContext);
} else
{
var source = report.getSourceReport();
return ctxt.getAPI().getTabularReport(source, reportContext);
}
}
function getReportView(reportContext, reportName)
{
var report = getReport(reportContext, reportName);
if (report == null)
{
logger.addError("No such report exists for the specified context "+reportName);
return null;
}
return new TableView(report);
}
var buffer = new StringWriter();
var printer = new PrintWriter(buffer);
var formatter = new com.cloupia.lib.util.managedreports.Formatter(new File("."), printer);
var AT = input.APICTenant;
logger.addInfo("Input : " + AT);
var x = AT.split('@');
logger.addInfo("Input 0 : " + x[0]);
logger.addInfo("Input 1 : " + x[1]);
var reportName="apic.tenant.appln.profile.report.config";
var repContext = util.createContextByType( "90160","","accountName=='" + x[0] +"' && name=='" + x[1] +"'");
var report = getReportView(repContext, reportName);
var numRowsFound = report.rowCount();
logger.addInfo("numRowsFound : " + numRowsFound);
var aa0 = report.getColumnValue(0, "DN");
logger.addInfo("DN: " + aa0);
//var a1 = report.getColumnValue(0, "Application Profile Name"); Apparently heading is actuall just Name
var aa1 = report.getColumnValue(0, "Name");
logger.addInfo("Application Profile Name: " + aa1);
var aa2 = report.getColumnValue(0, "Tenant ");
logger.addInfo("Tenant: " + aa2);
var aa3 = report.getColumnValue(0, "Description");
logger.addInfo("Description: " + aa3);
var aa4 = report.getColumnValue(0, "QoS Class");
logger.addInfo("QOS Class: " + aa4);
var sp = aa0.split('/');
logger.addInfo("DN 0: " + sp[0]);
logger.addInfo("DN 1: " + sp[1]);
logger.addInfo("Dn 2: " + sp[2]);
output.a0 = aa0;
output.a1 = aa1;
output.a2 = aa2;
output.a3 = aa3;
output.a4 = aa4;
output.dn0 = sp[0];
output.dn1 = sp[1];
output.dn2 = sp[2];
formatter.printTable(report);
printer.close();
