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