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
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
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.getProperty(“Number”)); System.log(resultRecords.getFieldNames()); First two lines… Continue reading vRO Read a custom query from a database
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);
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
SQL Statements are not case sensitive. However SQL keywords are written in all upper case. SQL statements should be terminated with semi colon ‘;’ , to define the end of each statement. How to create a blank database in MS SQL? CREATE DATABASE my_db; How to create tables in the database? CREATE TABLE Persons (… Continue reading Getting Started with SQL
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