Orchestrator

Generate CA Signed Certificate for vRO cluster

If you have a requirement to use CA signed SSL certificate for your vRO server cluster, you can use following steps to get your CA signed SSL certificate. You need to delete existing self signed  vRO certificate. keytool -delete -alias dunes -keystore “/etc/vco/app-server/security/jssecacerts” -storepass “dunesdunes” Note: With vRO 7 password for the certificate store has… Continue reading Generate CA Signed Certificate for vRO cluster

Orchestrator · SQL

vRO Execute a custom query on database

Run the workflow provided in the vRO “Execute a custom query on a database” Select the database and input the query you want to execute on the database. INSERT INTO LinuxVMs (VMName,RequestNumber,OSType,OwnerName) VALUES(‘linux001′,’12345′,’RHEL’,’admin’); Above query inserts values in table named LinuxVMs. First define the column names (VMName,RequestNumber,OSType,OwnerName) and then define values (‘linux001′,’12345′,’RHEL’,’admin’); These simple workflows… Continue reading vRO Execute a custom query on database

Orchestrator · SQL

vRO Read a custom query from a database

If you want to retrieve some information from database, you can run a workflow which is provided with default vRO plugin. The name of the workflow is “Read a custom query from a database” System.log(“Executing query ” + query + ” on database ” + database.name ); resultRecords = database.readCustomQuery(query); System.log(resultRecords[0].getProperty(“Number”)); System.log(resultRecords[0].getFieldNames()); First two lines… Continue reading vRO Read a custom query from a database

Orchestrator

Retrieve all vRA VMs

I find this useful in some operations to retrieve all vRA VMs to get the VM names / vCAC:VirtualMachine.

You can use following code in scriptable task to retrieve  vCAC:VirtualMachines.

var vRAVMs = Server.findAllForType("vCAC:VirtualMachine");

for each (i in vRAVMs)

{

if (i.VirtualMachineName == "mm130")

{
System.log("Found Virtual Machine you are looking for " +i.VirtualMachineName);
break;
 }

}
Powershell

Getting Started with PowerShell

Find Registered Snapin in Powershell Get-PSSnapin –Registered List Available modules on system Get-Module –ListAvailable Import available Modules Import-Module TroubleshootingPack Find Specific Commands from a module Get-Command -module TroubleshootingPack Find Commands using wildcards Get-Command -Name *event* -CommandType cmdlet,function Find commands based on verb and noun search Get-Command -Verb get -Noun ser* Find default PS Modules path… Continue reading Getting Started with PowerShell

Orchestrator

Replace vRO self Signed Certificate with new Self Signed Certificate

You might end up in a situation where you wanted to change the vRO self signed certificate and while doing so it got into a corrupt state.  In such case you can simply regenerate the self signed certificate and get your vRO server  up again and then proceed with CA signed certificate. Stop  vRO Server… Continue reading Replace vRO self Signed Certificate with new Self Signed Certificate