CUIC

IDS URL

  • 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


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

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'

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