This is an old revision of the document!
CUIC
IDS URL
https:<CUICSERVER>:8553/idsadmin/
===== Change Domain associated with user=====
* Take full backup prior to running command and test before and after
<code>
run sql update cuic_data:cuicuser set name=replace(name,'OLD-DOMAIN','NEW-DOMAIN') where name like 'OLD-DOMAIN\\%'
</code>
==== 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:
<code>
set web-security <orgunit> <orgname> <locality> <state> <country> <alternatehostname>
</code>
example
<code>
set web-security Telecoms PurplePi Dublin Leinster IE cuictst.ucce.purplepi.ie
</code>
note: if you need spaces in OrgUnit quote each variable, e.g.
<code>
set web-security “organization unit” “orgnization name” “city name” “state name” “united states” “whatever name you want in the certificate”
</code>
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.
<code>
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
</code>
After Generating the new certificate, you need to restart the tomcat service and cuic reporting server
<code>
utils service restart Cisco Tomcat
utils service restart Intelligence Center Reporting Service
</code>
==== 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
<code>
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
</code>
UCCE Config CUIC Report - https://communities.cisco.com/message/222869#222869
===== Custom Reports =====
*agent_event_detail_20180131v2.zip
*agent_logout.zip
*agent_historical_all_fields_with_avg_wrap.zip
*agent_attributes.zip
*agent_team_assignment.zip
*termination_call_detail_-_agent_team.zip
*termination_call_detail_-_agent.zip
*terminal_call_detail_-_by_peripheral_20180205.zip
*dialed_numers.zip
*dialednumber_-_calltype_-_script.zip
*bucket-config.zip
*ucce-system-info.zip
*call-type-sl-config.zip
*precision_queue_-_agent_teams_-_calls_handled.zip
===== Value Lists =====
Sample Value List “internal” reference Table - but only works if source is an Microsoft SQL Database
<code>
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
</code>
This one works when the source is CUIC !!!
<code>
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
</code>
Peripherals Value List
<code>
SELECT [PeripheralID] AS ID, [EnterpriseName] AS VALUE FROM [Peripheral] ORDER BY [EnterpriseName]
</code>
Persistent ECC Variables
<code>
SELECT [ExpandedCallVariableID] AS ID,[EnterpriseName] AS VALUE FROM [ucce_awdb].[dbo].[Expanded_Call_Variable] WHERE [Persistent] = 'Y'
</code>
===== 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.
<code>
set cuic properties host-to-ip
</code>