CUIC

CUIC

IDS URL

https://mycuicserver.mydomain.com:8553/idsadmin/

Change Domain associated with user

Take full backup prior to running command and test before and after

run sql update cuic_data:cuicuser set name=replace(name,'OLD-DOMAIN','NEW-DOMAIN') where name like 'OLD-DOMAIN\\%'

Creating SSL Certs with load balancer

You want to have a SSL cert for two servers, which can use the same DNS name. So the SSL certificate for both CUIC servers (or Finesse etc.) need to have a alterntive DNS name (Alternative Subject Name).

This can be done by updating the SSL certificate on the two CUIC servers. Note: this update need not invalidate the license file as long as you keep all other values of the certificate the same as they are presently.

Command:

set web-security <orgunit> <orgname> <locality> <state> <country> <alternatehostname>

example

set web-security Telecoms PurplePi Dublin Leinster IE cuictst.ucce.purplepi.ie

note: if you need spaces in OrgUnit quote each variable, e.g.

set web-security "organization unit" "orgnization name" "city name" "state name" "united states" "whatever name you want in the certificate"

To make sure to keep the rest of the certficate the same, (so a rehost of the license file is not required) use the following approach:

Confirm the existing License MAC Address (show status)
Using the below commands fill in and confirm you obtain the same License MAC using the Answer File http://www.cisco.com/web/cuc_afg/index.html

Use the same values for the SSL cert as you used in the Answer File.

show status
show web-security
(or you can use this command instead) show cert own tomcat/tomcat.pem 
show network eth0
utils ntp status
show smtp

After Generating the new certificate, you need to restart the tomcat service and cuic reporting server

utils service restart Cisco Tomcat
utils service restart Intelligence Center Reporting Service

Create a Copy of Report & Report Definition

Export the report
Edit the report XML
- Change the Report Name and Report Definition Name
- Change all the unique ID (Report, Report Definition & Fields etc) to an alternative value (try find and replace)

To Generate a trusted certificate - follow this process

Summary

Login to Operations System Admin and generate CSR
https://hostname/cmplatform - Reference
Cert.zip

Good Community CUIC Links

CUIC Report on CUIC Reports - https://communities.cisco.com/thread/66601

select
v.id,
c.name Folder,
v.name ReportName,
rd.name Definition,
v.description,
v.version,
v.cisco,
v.bypass,
v.layout,
v.partition,
v.sharingpermission,
u.name Owner,
trim(v.url),
v.templatehelpid,
v.entityversion,
v.author
from cuicreport v, cuiccategory c, cuicreportdefinition rd, outer cuicuser u
where v.parentcategoryid= c.id
and v.reportdefinitionid=rd.id
and v.owner=u.id

UCCE Config CUIC Report - https://communities.cisco.com/message/222869#222869

Custom Reports

Value Lists

Sample Value List “internal” reference Table - but only works if source is an Microsoft SQL Database

SELECT 1 AS ID,'Reason Code 1' AS VALUE UNION
SELECT 2 AS ID,'Reason Code 2' AS VALUE UNION
SELECT 5 AS ID,'Reason Code 5' AS VALUE 
ORDER BY ID

This one works when the source is CUIC !!!

SELECT 1 as ID, 'Reason Code 1' as VALUE from cuicreport UNION
SELECT 2 as ID, 'Reason Code 2' as VALUE from cuicreport UNION
SELECT 5 as ID, 'Reason Code 5' as VALUE from cuicreport

Peripherals Value List

SELECT [PeripheralID] AS ID, [EnterpriseName] AS VALUE FROM [Peripheral] ORDER BY [EnterpriseName]

Persistent ECC Variables

SELECT [ExpandedCallVariableID] AS ID,[EnterpriseName] AS VALUE  FROM [ucce_awdb].[dbo].[Expanded_Call_Variable] WHERE [Persistent] = 'Y'

Setting HostName in CUIC

You can distribute the reporting load to several UCCE AW_HDS databases using the Command Line Interface and conventional name resolution. If there is a need to direct a specific member node to a database host other than the one in configured on the Data Sources interface, you can use the set cuic-properties host-to-ip command to resolve the data source name differently on each node.

Any given reporting member node can be directed to a specific UCCE database.

set cuic properties host-to-ip

Real Time Logs for Report Defination Errors

List the Logs files and fine the Error log file name

file list activelog cuic/logs/cuic/*

Tail the error log and repeat the issue

file tail activelog cuic/logs/cuic/Error-cuic.2020-01-24T11-42-32.271.startup.log

Some handy TAC commands

utils diagnose test
run sql select * from processnode
run sql select * from mmca_server
run sql select * from mmca_device
run sql select * from mmca_propertydef where propertyname like '%hazelcast%

Hazelcast troubleshooting

http://<CUIC-IP>:57011/hazelcast/rest/cluster
http://<CUIC-IP>:57011/hazelcast/health

From Publisher:

utils network connectivity <Sub_IP> 57011

From Subscriber:

utils network connectivity <Pub_IP> 57011

show open ports regexp 57011

and the following commands as well
From Publisher:

utils network connectivity <Sub_IP> 57011

From Subscriber:

utils network connectivity <Pub_IP> 57011

Scheduled Reports SQL

run sql select * from cuic_data:cuicscheduledreports where ScheduledReportName = 'Gerry - eirSupport'

run sql update cuic_data:cuicscheduledreports set language ='en_UK' where ScheduledReportName = 'Gerry - eirSupport'

FIX Scheduled Reports SQL Issue with EXCEL in US format

run sql select * from cuic_data:cuicscheduledreports where language ='en_US'

run sql update cuic_data:cuicscheduledreports set language ='en_UK' where language ='en_US'

Table of Contents