PDF(89.0 KB) View with Adobe Reader on a variety of devices
ePub(81.0 KB) View in various apps on iPhone, iPad, Android, Sony Reader, or Windows Phone
Mobi (Kindle)(67.7 KB) View on Kindle device or Kindle app on multiple devices
Updated:October 22, 2019
The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.
This document describes the procedure to find out version of stock Cisco Unified Intelligence Center (CUIC) reports.
There are no specific requirements for this document.
The information in this document is based on these software and hardware versions:
Cisco Unified Contact Center Enterprise (UCCE) 11.6
The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, ensure that you understand the potential impact of any command.
In case of multiple software upgrades of UCCE and CUIC, mismatched stock reports might stay in the system. It can result in incorrect data reports. The stock reports of current UCCE version must be downloaded and deployed due to schema changes across different versions.
How to verify version information of CUIC stock reports?
Step 1. Save old templates to local PC for rollback purpose
Step 2. Import report templates for the current UCCE version
Step 3.Run this query in order to get the version information
Step 4. Use this query in order to find the reports that are associated with a report definition:
run sql select name from cuic_data:cuicreport where reportdefinitionid = ‘<repDefId>’
admin:run sql select name from cuic_data:cuicreport where reportdefinitionid = 'DAE861621000012F130C07393F57E6DF' name
Step 5. Use this query in order to shows all reports, their IDs, names and descriptions:
admin:run sql select id, name, description from cuic_data:cuicreport
id name description
================================ ====================================================== ======================================================
81D1F50E10000132146C556B0A4E5BC4 Audit Trail
CCCCCCCC00000000CCCCCCCC00000016 Enterprise Skill Group Real Time
CCCCCCCC00000000CCCCCCCC00000021 Peripheral Skill Group Real Time All Fields
596F34E4100001360C400CF10A4D41E2 [SystemCapacity] [SystemCapacity]
CCCCCCCC00000000CCCCCCCC00000012 Call Type Real Time
428B34DE1000012F1ACF4E563F57E6DF [Agent_Real_Time] [Agent_Real_Time]
CCCCCCCC00000000CCCCCCCC00000019 Peripheral Service Real Time All Fields
E6BD1317100001371903A9C40A00060D [Agent_Queue_Real_Time] [Agent_Queue_Real_Time]
CCCCCCCC00000000CCCCCCCC00000005 Agent Skill Group Real Time
6891A67A1000012F0E86370B3F57E6DF [Agent_Precision_Queue_Membership] [Agent_Precision_Queue_Membership]
3605F9341000013672B57E420A00060D [Precision_Queue_Step_Real_Time] [Precision_Queue_Step_Real_Time]
479C77E01000012F34837F4F3F57E6DF Precision Queue Real Time All Fields [Precision_Queue_Real_Time_All_Flds]
453C713F1000012F5A0DC7E63F57E6DF [Agent_Team_Real_Time] [Agent_Team_Real_Time]
CCCCCCCC00000000CCCCCCCC00000011 Call_Type_Historical_All_Fields Call_Type_Historical_All_Fields
3B2D347A100001362E3DD7C40A00060D Precision_Queue_Efficiency Precision_Queue_Efficiency