Cisco Unified Contact Center Express Command Line Interface Reference Guide, Release 9.0(2)
Run Commands
Downloads: This chapterpdf (PDF - 1.08MB) The complete bookPDF (PDF - 2.57MB) | The complete bookePub (ePub - 251.0KB) | Feedback

Run Commands

Run Commands

run uccx sql database_name sql_query

Executes an SQL "select" statement from the CLI. Read-only operations are permitted. Insert, Update, Delete and any DML statements are disallowed. This command allows queries to be run against the Unified CCX databases (data stores) and sysmaster database for the Unified CCX Informix instance (IDS engine).

Command Syntax:

run uccx sql database_name sql_query [options]

Arguments

  • database_name—mandatory; database on which the SQL statement will be run
  • sql_query—mandatory; the sql statement to run Options
  • page—displays the output one page at a time
  • file—stores the output to a file instead of showing it on the console. The name of the file will be displayed after the completion of the command.

Requirements

Level privilege—0

Command privilege level—0

Allowed during upgrade—No

Example

admin:run uccx sql db_cra select resourceid,resourcename from resourceRESOURCEID      RESOURCENAME
-----------------------
1        b
2        Joshi
3        sacagent3
4        sacagent1
7        user
8        sacagent2
9       ankit agent2
10      ankit rtlite1
11       agent130
14       sk1
15       sk2
24      Ankit RT Pro

run uccx sp database_name sp_name

Executes a stored procedure specified as a parameter on the database, which is also mentioned as a parameter. This command only runs a stored procedure.

Command Syntax:

run uccx sp database_name sp_name [options]

Arguments

  • database_name—mandatory; database on which the stored procedure will be run
  • sp_name—mandatory; the stored procedure to be run Options
  • page—displays the output one page at a time
  • file—stores the output to a file instead of showing it on the console. The name of the file will be displayed after the completion of the command.

Requirements

Level privilege—0

Command privilege level—0

Allowed during upgrade—No

Example

admin:run uccx sp db_cra sp_ivr_traffic_analysis('2008-11-20 00:00:00', '2008-12-20 00:00:00', 0)DATEVALUE       TOTAL_INCOMING_CALLS    AVG_CALLS       PEAK_CALLS      START_PEAK_HOUR END_PEAK_HOUR   AVG_CALL_LENGTH MIN_CALL_LENGTH       MAX_CALL_LENGTH FINAL_AVG_CALLS FINAL_AVG_CALL_LEN      LATESTSYNCHEDTIME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 No records found.

 Command successful.