This is an old revision of the document!


CUIC

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>

  • vendors/cisco/uc/cuic.1540477510.txt.gz
  • Last modified: 2018/10/25 15:25
  • by gerardorourke