UCCX
UCCX Scripts
Resilience
When the subscriber goes down and it is required to make configuration updates from the publisher, you can disable Config Datastore (CDS) and Historical Datastore (HDS) on the subscriber using Disable CDS and HDS icon or button. The database information for the cluster is displayed at the bottom of the window. Once the subscriber is up, you can enable CDS and HDS on the subscriber using the same toggle button.
Caution Any configuration in Application Administration and Historical data on the Subscriber node would get over written, when CDS is enabled again.
Choose Tools > Datastore Control Center > Replication Servers from the Unified CCX Serviceability menu bar.
https://supportforums.cisco.com/blog/12049551/community-tech-talk-cisco-unified-contact-center-express-uccx-version-100-upgrade
UCCX Documentation
https://supportforums.cisco.com/discussion/11308371/uccx-script-pull-xml-data
https://supportforums.cisco.com/document/112046/uccx-discovering-exceptions
Email & Chat
http://www.tympaniinc.com/advanced-technology-blog/PostId/177/email-queuing-comes-to-finesse-in-uccx-106
Admin Guide
http://www.cisco.com/c/en/us/support/customer-collaboration/unified-contact-center-express/products-installation-and-configuration-guides-list.html
UCCX 10.6 Sales Presentation
https://communities.cisco.com/docs/DOC-56253
UCCX 10.5 Sales Presentation
https://communities.cisco.com/docs/DOC-53736
Wallboard
Tools→Password Management
http://www.cisco.com/c/en/us/support/docs/customer-collaboration/unified-contact-center-express/116798-technote-uccx-00.html
Informix SDK
Informix Downloads (Informix Client SDK Developer Edition for Windows x86_64, 64-bit
CUIC Reports to get Database details
https://communities.cisco.com/message/187099#187099
You can check the user id with a simple CUIC report: "select username, user type from sysusers", your userid should show in that result set. You can check the database name with another simple CUIC report: "select name from sysmaster:sysdatabases" You can check the server with another simple CUIC report: "select cf_name, cf_effective from sys master:sysconfig where cf_name='DBSERVERNAME'"
UCCX CUIC Custom Reports
If you want to use the password that you are setting in Password Management, then the user will need to be changed from uccxhrc to uccxhruser as well which is not recommended to use.
Or use the default password set for uccxhrc - which is documented in link below:
- Create custom version of existing Store Procedure
- Create custom version of drop_table and use this in your custom precdure, e.g.
create procedure "uccxhruser".drop_table_custom(l_tabname varchar(250)) begin on exception in (-206) end exception; execute immediate 'drop table ' || l_tabname; end; end procedure; -- Permissions for routine "drop_table_custom" revoke execute on procedure 'uccxhruser'.drop_table_custom(varchar) from 'public';
Beaware of this bug which has still not be fixed in Version 10.6
https://bst.cloudapps.cisco.com/bugsearch/bug/CSCul06940
Informix Version Check
UCCX 10.6 = > IBM Informix Dynamic Server Version 11.70.UC7XA
select first 1 dbinfo("version", "full") from systables;
Informix Client for UCCX
Server Studio by AGS Ltd
https://www.serverstudio.com/
VMware Tool 10 Bug
https://bst.cloudapps.cisco.com/bugsearch/bug/CSCux90747/?referring_site=bugquickviewredir
This Fix is INCLUDED is CUCM 11.0 SU2 - so no need to install on CUCM
https://software.cisco.com/download/release.html?mdfid=286284802&flowid=77897&softwareid=282204704&release=COP-Files&relind=AVAILABLE&rellifecycle=&reltype=latest
Readme
http://www.cisco.com/web/software/282204704/18582/ciscocm.VMwareTools2016aReadme.pdf
For UCCX 11.0 this is nto included in SU1 - so install below (note a different COP file to the CUCM one)
https://software.cisco.com/download/release.html?mdfid=286287033&flowid=76362&softwareid=280840578&release=Leapsecond&relind=AVAILABLE&rellifecycle=&reltype=latest
Readme
http://www.cisco.com/web/software/280840578/133320/ReadMe-UCCX-10.5.1-10.6.1-11.0.1-VMwareToolsV2.pdf
After install use the following command: “utils vmtools caf-logs delete”
Check if string variable is a number
Thanks to Anthony Holloway
Reference https://docs.oracle.com/javase/7/docs/api/java/lang/String.html