UCCE Live Data

• https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/icm_enterprise/icm_enterprise_12_0_1/Configuration/Guide/ucce_b_12-serviceability-guide/ucce_b_1171-serviceability-guide_chapter_01011.html
• show socketio status

Create an SQL user cuicuser and give read access to aw, hds and master database. Then using admin sql execute the below on each HDS Server.

USE master
GO
GRANT CONTROL ON CERTIFICATE :: UCCESymmetricKeyCertificate TO "cuicuser"
GRANT VIEW DEFINITION ON SYMMETRIC KEY :: UCCESymmetricKey TO "cuicuser"

admin:set live-data aw-access primary 123.123.123.123 1433 ucce_awdb cuicuser <Password>

Primary AW access information:

 address          | port | db_name   | user
------------------+------+-----------+----------
 123.123.123.123  | 1433 | ucce_awdb | cuicuser

Test: Succeeded
Executed command successfully

Use the [email protected] format to specify the AW database domain user with write-access permission. The domain is a fully qualified domain name (FQDN), and the username is a user principal name. You must be authorized to change Unified CCE configuration.

Command: set live-data machine-services awdb-user awdb-pwd

admin:set live-data machine-services [email protected] <password>

Warning: failed to retrieve Subscriber FQDN
  ad.ucce-dev.mydomain.pri: side A
        | ACTIVE_MQ               | 61616 |                                  |
        | STORM_DRPC              |  3772 |                                  |
        | LIVE_DATA_WEB_SOCKETS   | 12008 |                                  |
        | LIVE_DATA_API           | 12005 | livedata                         |
        | LIVE_DATA_CASSANDRA     | 12000 |                                  |
  UNKNOWN: side B
        | ACTIVE_MQ               | 61616 |                                  |
        | STORM_DRPC              |  3772 |                                  |
        | LIVE_DATA_WEB_SOCKETS   | 12008 |                                  |
        | LIVE_DATA_API           | 12005 | livedata                         |
        | LIVE_DATA_CASSANDRA     | 12000 |                                  |
admin:

set live-data cuic-datasource cuic-addr cuic-port cuic-user cuic-pwd

set live-data cuic-datasource 123.123.123.123 8444 CUIC\admin <password>

Warning: Live Data Side B is not configured.  Failover will be disabled.

Id: AF4627EF1000015B0000015E0A18230C
Name: Live Data Streaming Data Source
Type: Streaming
Time Zone: UTC
Side A:
   CCE Live Data Service host: ad.mydomain.pri
   CCE Live Data Web Service port: 12005
   CCE Live Data Socket.IO Service port: 12008
   CCE Live Data Schema URL: livedata/livedataSchema.xml
   CCE Live Data Token Service URL: livedata/token/new
   Credentials not displayed
admin:

For LiveData reports, the Data Source for ReportDefinition is LiveData Streaming and the Data Source for ValueList is UCCE Realtime

file get activelog livedata/logs/*/*
file list activelog livedata/logs/livedata-storm/*
file tail activelog livedata/logs/livedata-storm/worker-6702.log
file tail activelog livedata/logs/livedata-storm/nimbus.log

netstat -anb| findstr "4*03[45]"

show socketio status
show live-data failover
show service list
utils ntp status 
show open ports regexp :4[0-5]03[45]
show live-data aw-access

• In the Data Source for ReportDefinition field, select UCCE Historical. • In the Datasource for ValueList field, select CUIC.