Native
Synchronous
No Custom Parameters
The ExecuteSQLQuery action allows a developer to issue a custom SQL query against the Cisco Unified Communications Manager database.
ExecuteSQLQuery requires knowledge of the Cisco Unified Communications Manager database, which can be obtained by referencing the Data Dictionary document which can be downloaded from the Cisco Unified Communciations Manager web-based administration interface.
The resulting ExecuteSQLQueryResponse object can be subsequently passed into the ParseSQLQuery action to convert the response to a System.Data.DataTable.
The ExecuteSQLQuery action is inherently very Cisco Unified Communications Manager version-specific. You should carefully test which versions of Cisco Unified Communications Manager your script works with if using this action.
| Parameter Name | .NET Type | Default | Description |
|---|---|---|---|
| Query | System.String | The SQL query | |
| CallManagerIP * | System.String | CallManager IP Address | |
| AdminUsername | System.String | The Administrator username. Defaults to 'Administrator' | |
| AdminPassword * | System.String | The Administrator password |
| Parameter Name | .NET Type | Description |
|---|---|---|
| ExecuteSQLQueryResponse | Metreos.AxlSoap504.executeSQLQueryResponse | The details of the query |
| FaultMessage | System.String | The textual description of the SOAP fault, if a fault occurs |
| FaultCode | System.Int32 | The numeric code of a SOAP fault, if a fault occurs |
Branch Conditions
No description.
No description.
No description.