7.2

Table 4‑5. PowerShell Script Custom Property Configuration Values (Continued)
Option Value
Display as Dropdown
Values External
Action folder com.vmware.vra.powershell
Script action Select an action based on where the PowerShell script is located.
n
If the PowerShell script is on a central server, use
executeExternalPowerShellScriptOnHostByName.
n
If the PowerShell script is uploaded into vRealize Orchestrator, use
executePowershellScriptFromResourceOnHostByName.
These script actions are example scripts. You can create specic actions for
your environment.
Input parameters Congure the input parameters based on the selected action.
Dene parameters
n
If you use executeExternalPowerShellScriptOnHostByName:
n
hostName. Name of the central server where the script is located.
n
externalPowershellScript. Path to the PowerShell le on the host.
n
Arguments. Parameters to pass to the script. You separate the
arguments with commas. For example, Argument1,Arguement2.
n
If you use executePowershellScriptFromResourceOnHostByName:
n
vRealize Orchestrator. Name of the vRealize Orchestrator instance
you are using as the host.
n
scriptResourcePath. Path to the PowerShell le on the host.
n
scriptResourceName. Path to the PowerShell le as an uploaded
resource in vRealize Orchestrator.
Blueprint Configuration
To add the custom property to the blueprint Properties tab, see “Add a Custom Property or Property Group
as a Blueprint Machine Property,” on page 98.
Database Query Custom Property Definition
You add a custom property to query a database when you want to retrieve values from that database to
populate the custom property on the request form. The database custom property uses a
vRealize Orchestrator action to run the query and retrieve the values.
The action is supported for the following databases:
n
Microsoft SQL Server
n
MySQL
n
Oracle
n
PostgreSQL
Limitations
All retrieved values are converted to strings.
Prerequisites
Verify that the vRealize Orchestrator SQL Plug-In is installed and congured to connect to the target
database.
Custom Properties Reference
104 VMware, Inc.