cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays

CUIC - UCCX Stored Procedure List (Pulled from V11.5)

3956
Views
10
Helpful
2
Comments
Report Stored Procedure
Abandoned Call Detail Activity sp_abandoned_calls_activity
Aborted Rejected Call Detail sp_aborted_rejected_call_detail
Agent All Fields sp_agent_all_fields
Agent Call Summary sp_agent_call_summary
Agent Detail sp_agent_detail
Agent Login Logout Activity sp_agent_log_activity
Agent Not Ready Reason Code Summary sp_agent_not_ready_reason_code_interval
Agent State Detail sp_agent_state_detail
Agent State Summary by Agent sp_agent_state_interval
Agent State Summary by Interval sp_agent_state_interval
Agent Summary Report sp_agent_summary
Agent Wrap Up Data Summary sp_agent_wrapup_summary
Agent Wrap-Up Data Detail sp_agent_wrapup_detail
Call Custom Variables sp_custom_variable
Called Number Summary Activity sp_called_number_summary_activity
Common Skill CSQ Activity sp_common_skill_csq_interval
Contact Service Queue Activity by CSQ sp_csq_interval
Contact Service Queue Activity by Window Duration sp_csq_interval2
Contact Service Queue Activity sp_csq_activity
Contact Service Queue Activity by Interval sp_csq_interval
Contact Service Queue Call Distribution Summary sp_csq_call_distribution
Contact Service Queue Service Priority Summary sp_csq_priority_summary
Contact Service Queue Service Level Priority Summary sp_csq_service_level_priority
CSQ Agent Summary sp_csq_agent_summary
CSQ All Feilds Report sp_csq_all_fields
Detailed Call by Call CCDR sp_ccdr
Detailed Call CSQ Agent sp_call_csq_agent
Priority Summary Activity Report sp_priority_summary
Reason Code Report by Agent Grouping sp_reasoncode_agent_grouping
Reason Code Report by Reason Code Grouping sp_reasoncode_reason_grouping
Traffic Analysis sp_ivr_traffic_analysis_cuic
Comments
fabien_damien
Beginner

Hello Joey,

 

do you have the list of parameters that these SP take?

 

Thanks. 

ryan.roline
Beginner

Hi Joey, 

 

I was able to retrieve the parameter lists and datatypes for each stored procedure and added them to your list. 

 

 

ReportStored ProcedureProcedure Parameters & Data Types
Abandoned Call Detail Activitysp_abandoned_calls_activitysp_abandoned_calls_activity(
p_startTime DATETIME YEAR TO FRACTION(3),
p_endTime DATETIME YEAR TO FRACTION(3),
p_sortBy INT DEFAULT 0,
p_agentList LVARCHAR(4000) DEFAULT 'NULL',
                    p_user LVARCHAR(4000) DEFAULT 'NULL')
Aborted Rejected Call Detailsp_aborted_rejected_call_detailsp_aborted_rejected_call_detail(p_startTime DATETIME YEAR TO FRACTION(3),
                                                p_endTime DATETIME YEAR TO FRACTION(3),
                                                p_sortBy INT DEFAULT 0,
                                                p_contactDisposition NVARCHAR(100) DEFAULT 'NULL')
Agent All Fieldssp_agent_all_fieldssp_agent_all_fields
(  
      p_startTime DATETIME YEAR TO FRACTION(3),                   
          p_endTime DATETIME YEAR TO FRACTION(3),        
          p_sortBy INT DEFAULT 0,        
          p_resGroupList LVARCHAR(4000) DEFAULT 'NULL',
          p_agentList LVARCHAR(4000) DEFAULT 'NULL',
          p_skillList LVARCHAR(4000) DEFAULT 'NULL',       
          p_teamList LVARCHAR(4000) DEFAULT 'NULL',
          p_user LVARCHAR(4000) DEFAULT 'NULL')
Agent Call Summarysp_agent_call_summarysp_agent_call_summary(p_startTime DATETIME YEAR TO FRACTION(3),
                                       p_endTime DATETIME YEAR TO FRACTION(3),
                                       p_sortBy int DEFAULT 0,                       
                                       p_resGroupList LVARCHAR(4000) DEFAULT 'NULL',
                                       p_agentList LVARCHAR(4000) DEFAULT 'NULL',
                                       p_skillList LVARCHAR(4000) DEFAULT 'NULL',
                                       p_teamList LVARCHAR(4000) DEFAULT 'NULL',
                                       p_user LVARCHAR(4000) DEFAULT 'NULL')
Agent Detailsp_agent_detailsp_agent_detail(p_starttime  datetime year to fraction(3),
                                 p_endtime  datetime year to fraction(3),
                                 p_sortby int default 0,
                                 p_resgrouplist lvarchar(4000) default 'null',
                                 p_agentlist lvarchar(4000) default 'null',
                                 p_skilllist lvarchar(4000) default 'null',
                                 p_teamlist lvarchar(4000) default 'null',
                                 p_calltypelist lvarchar(4000) default 'null',
                 p_user LVARCHAR(4000) DEFAULT 'NULL')
Agent Login Logout Activitysp_agent_log_activitysp_agent_log_activity(p_startTime DATETIME YEAR TO FRACTION(3),
                                       p_endTime DATETIME YEAR TO FRACTION(3),
                                       p_sortBy int DEFAULT 0,
                                       p_resGroupList LVARCHAR(4000) DEFAULT 'NULL',
                                       p_agentList LVARCHAR(4000) DEFAULT 'NULL',
                                       p_skillList LVARCHAR(4000) DEFAULT 'NULL',
                                       p_teamList LVARCHAR(4000) DEFAULT 'NULL',
                                       p_user LVARCHAR(4000) DEFAULT 'NULL')
Agent Not Ready Reason Code Summarysp_agent_not_ready_reason_code_interval sp_agent_not_ready_reason_code_interval (
               p_startTime DATETIME YEAR TO FRACTION(3),
               p_endTime DATETIME YEAR TO FRACTION(3),
               p_intLen INT DEFAULT 0,
               p_sortBy INT DEFAULT 0,
               p_resGroupList LVARCHAR(4000) DEFAULT 'NULL',
               p_agentList LVARCHAR(4000) DEFAULT 'NULL',
               p_skillList LVARCHAR(4000) DEFAULT 'NULL',
               p_teamList LVARCHAR(4000) DEFAULT 'NULL',
               p_reasonCodeList NVARCHAR(200) DEFAULT 'NULL' ,
               p_user LVARCHAR(4000) DEFAULT 'NULL')
Agent State Detailsp_agent_state_detailsp_agent_state_detail (p_startTime DATETIME YEAR TO FRACTION(3),
                                       p_endTime DATETIME YEAR TO FRACTION(3),
                                       p_sortBy INT DEFAULT 0,
                                       p_resGroupList LVARCHAR(4000) DEFAULT 'NULL',
                                       p_agentList LVARCHAR(4000) DEFAULT 'NULL',
                                       p_skillList LVARCHAR(4000) DEFAULT 'NULL',
                                       p_teamList LVARCHAR(4000) DEFAULT 'NULL',
                                           p_user LVARCHAR(4000) DEFAULT 'NULL' )
Agent State Summary by Agentsp_agent_state_intervalsp_agent_state_interval (p_startTime DATETIME YEAR TO FRACTION(3),
                                         p_endTime DATETIME YEAR TO FRACTION(3),
                                         p_intLen INT DEFAULT 0,
                                         p_sortBy INT DEFAULT 0,
                                         p_resGroupList LVARCHAR(4000) DEFAULT 'NULL',
                                         p_agentList LVARCHAR(4000) DEFAULT 'NULL',
                                         p_skillList LVARCHAR(4000) DEFAULT 'NULL',
                                         p_teamList LVARCHAR(4000) DEFAULT 'NULL' ,
                                         p_user LVARCHAR(4000) DEFAULT 'NULL')
Agent State Summary by Intervalsp_agent_state_intervalsp_agent_state_interval (p_startTime DATETIME YEAR TO FRACTION(3),
                                         p_endTime DATETIME YEAR TO FRACTION(3),
                                         p_intLen INT DEFAULT 0,
                                         p_sortBy INT DEFAULT 0,
                                         p_resGroupList LVARCHAR(4000) DEFAULT 'NULL',
                                         p_agentList LVARCHAR(4000) DEFAULT 'NULL',
                                         p_skillList LVARCHAR(4000) DEFAULT 'NULL',
                                         p_teamList LVARCHAR(4000) DEFAULT 'NULL' ,
                                         p_user LVARCHAR(4000) DEFAULT 'NULL')
Agent Summary Reportsp_agent_summarysp_agent_summary(p_startTime DATETIME YEAR TO FRACTION(3),                   
                                  p_endTime DATETIME YEAR TO FRACTION(3),        
                                  p_sortBy INT DEFAULT 0,        
                                  p_resGroupList LVARCHAR(4000) DEFAULT 'NULL',
                                  p_agentList LVARCHAR(4000) DEFAULT 'NULL',
                                  p_skillList LVARCHAR(4000) DEFAULT 'NULL',
                                  p_teamList LVARCHAR(4000) DEFAULT 'NULL',
                                  p_topNratio INT DEFAULT 0,
                                  p_bottomNratio INT DEFAULT 0,
                                  p_topNhold INT DEFAULT 0,
                                  p_bottomNhold INT DEFAULT 0,
                                  p_topNtalk INT DEFAULT 0,
                                  p_bottomNtalk INT DEFAULT 0,
                                  p_topNwrap INT DEFAULT 0,
                                  p_bottomNwrap INT DEFAULT 0,
                                  p_topNhandle INT DEFAULT 0,
                                  p_bottomNhandle INT DEFAULT 0,
  p_user LVARCHAR(4000) DEFAULT 'NULL')
Agent Wrap Up Data Summarysp_agent_wrapup_summarysp_agent_wrapup_summary (
p_startTime DATETIME YEAR TO FRACTION(3),
p_endTime DATETIME YEAR TO FRACTION(3),
p_sortBy INT DEFAULT 0,
p_wrapupDataList LVARCHAR(4000) DEFAULT 'NULL')
Agent Wrap-Up Data Detailsp_agent_wrapup_detailsp_agent_wrapup_detail(
p_startTime DATETIME YEAR TO FRACTION(3),
p_endTime DATETIME YEAR TO FRACTION(3),
p_sortBy INT DEFAULT 0,
p_resGroupList LVARCHAR(4000) DEFAULT 'NULL',
p_agentList LVARCHAR(4000) DEFAULT 'NULL',
p_skillList LVARCHAR(4000) DEFAULT 'NULL',
p_teamList LVARCHAR(4000) DEFAULT 'NULL',
p_user LVARCHAR(4000) DEFAULT 'NULL')
Call Custom Variablessp_custom_variablesp_custom_variable (
p_startTime DATETIME YEAR TO FRACTION(3),
p_endTime DATETIME YEAR TO FRACTION(3),
p_sortBy INT DEFAULT 0,
p_origCalledNumber LVARCHAR(4000) DEFAULT 'NULL',
p_calledNumber LVARCHAR(4000) DEFAULT 'NULL',
p_callingNumber LVARCHAR(4000) DEFAULT 'NULL',
p_applicationName LVARCHAR(4000) DEFAULT 'NULL',
p_contactType NVARCHAR(100) DEFAULT 'NULL',
p_originatorType NVARCHAR(100) DEFAULT 'NULL',
p_destinationType NVARCHAR(100) DEFAULT 'NULL',
p_durationGreaterThanEqualTo INT DEFAULT -1,
p_durationLessThanEqualTo INT DEFAULT -1,
p_customVariable1 NVARCHAR(250) DEFAULT 'NULL',
p_customVariable2 NVARCHAR(250) DEFAULT 'NULL',
p_customVariable3 NVARCHAR(250) DEFAULT 'NULL',
p_customVariable4 NVARCHAR(250) DEFAULT 'NULL',
p_customVariable5 NVARCHAR(250) DEFAULT 'NULL',
p_customVariable6 NVARCHAR(250) DEFAULT 'NULL',
p_customVariable7 NVARCHAR(250) DEFAULT 'NULL',
p_customVariable8 NVARCHAR(250) DEFAULT 'NULL',
p_customVariable9 NVARCHAR(250) DEFAULT 'NULL',
p_customVariable10 NVARCHAR(250) DEFAULT 'NULL',
p_customVariableAny NVARCHAR(250) DEFAULT 'NULL' )
Called Number Summary Activitysp_called_number_summary_activitysp_called_number_summary_activity (
p_startTime DATETIME YEAR TO FRACTION(3),
p_endTime DATETIME YEAR TO FRACTION(3),
p_sortBy INT DEFAULT 0,
                                        p_offset VARCHAR(20) DEFAULT '0')
Common Skill CSQ Activitysp_common_skill_csq_intervalsp_common_skill_csq_interval(p_starttime DATETIME YEAR TO SECOND,
                                             p_endtime DATETIME YEAR TO SECOND,
                                             p_intlen INT DEFAULT 0,
                                             p_sortby INT DEFAULT -1,
                                             p_csqlist LVARCHAR(4000) DEFAULT 'NULL',
                         p_user LVARCHAR(4000) DEFAULT 'NULL')
Contact Service Queue Activity by CSQsp_csq_intervalsp_csq_interval(p_starttime DATETIME YEAR TO SECOND
                              , p_endtime DATETIME YEAR TO SECOND
                              , p_intlen INT DEFAULT 0
                              , p_sortby INT DEFAULT 0
                              , p_csqlist LVARCHAR(4000) DEFAULT 'NULL'
                              , p_user LVARCHAR(4000) DEFAULT 'NULL')
Contact Service Queue Activity by Window Durationsp_csq_interval2sp_csq_interval2(
                                  p_starttime DATETIME YEAR TO SECOND
                                , p_endtime DATETIME YEAR TO SECOND
                                , p_intlen INT DEFAULT 0
                                , p_sortby INT DEFAULT 0
    , p_offset varchar(20) default '0' -- No offset from UTC
                                , p_csqlist LVARCHAR(4000) DEFAULT 'NULL'
                                , p_user LVARCHAR(4000) DEFAULT 'NULL'
                                )
Contact Service Queue Activitysp_csq_activitysp_csq_activity(p_starttime DATETIME YEAR TO SECOND,
                                p_endtime DATETIME YEAR TO SECOND,
                                p_sortby INT DEFAULT 0,
                                p_csqlist LVARCHAR(4000) DEFAULT 'NULL',
                                p_csqtype NVARCHAR(50) DEFAULT 'NULL',
                    p_user LVARCHAR(4000) DEFAULT 'NULL')
Contact Service Queue Activity by Intervalsp_csq_intervalsp_csq_interval(p_starttime DATETIME YEAR TO SECOND
                              , p_endtime DATETIME YEAR TO SECOND
                              , p_intlen INT DEFAULT 0
                              , p_sortby INT DEFAULT 0
                              , p_csqlist LVARCHAR(4000) DEFAULT 'NULL'
                              , p_user LVARCHAR(4000) DEFAULT 'NULL')
Contact Service Queue Call Distribution Summarysp_csq_call_distributionsp_csq_call_distribution(p_starttime DATETIME YEAR TO SECOND
                                        , p_endtime DATETIME YEAR TO SECOND
                                        , p_sortby INT DEFAULT 0
                                        , p_timebucketlength INT DEFAULT 15
                                        , p_csqlist LVARCHAR(4000) DEFAULT 'NULL'
                    ,p_user LVARCHAR(4000) DEFAULT 'NULL')
Contact Service Queue Service Priority Summarysp_csq_priority_summarysp_csq_priority_summary(p_startTime  DATETIME YEAR TO FRACTION(3),
                                         p_endTime  DATETIME YEAR TO FRACTION(3),
                                         p_sortBy INT DEFAULT 0,
                                         p_csqList LVARCHAR(4000) DEFAULT 'NULL',
                                         p_offset VARCHAR(20) DEFAULT '0',
                                         p_user LVARCHAR(4000) DEFAULT 'NULL')
Contact Service Queue Service Level Priority Summarysp_csq_service_level_prioritysp_csq_service_level_priority( p_starttime DATETIME YEAR TO SECOND,
                                               p_endtime DATETIME YEAR TO SECOND,
                                               p_sortby INT DEFAULT 0,
                                               p_csqlist LVARCHAR(4000) DEFAULT 'NULL',
                                               p_user LVARCHAR(4000) DEFAULT 'NULL')
CSQ Agent Summarysp_csq_agent_summarysp_csq_agent_summary(p_starttime DATETIME YEAR TO SECOND,
                                      p_endtime DATETIME YEAR TO SECOND,
                                      p_sortby INT DEFAULT 0,
                                      p_csqlist LVARCHAR(4000) DEFAULT 'NULL',
                      p_user LVARCHAR(4000) DEFAULT 'NULL')
CSQ All Feilds Reportsp_csq_all_fieldssp_csq_all_fields(p_starttime DATETIME YEAR TO SECOND
                                , p_endtime DATETIME YEAR TO SECOND                              
                                , p_sortby INT DEFAULT 0
                                , p_csqlist NCHAR(4000) DEFAULT 'NULL'
                                , p_user LVARCHAR(4000) DEFAULT 'NULL')
Detailed Call by Call CCDRsp_ccdrsp_ccdr(p_starttime, p_endtime, p_sortby, 'NULL', p_calledNumber,
                                        p_callingNumber, p_applicationName, p_contactType,
                                        p_originatorType, p_destinationType, p_durationGreaterThanEqualTo,
                                        p_durationLessThanEqualTo, p_resourceName, p_csqName,'t',p_user)
Detailed Call CSQ Agentsp_call_csq_agentsp_call_csq_agent( p_starttime DATETIME YEAR TO SECOND,
                                   p_endtime DATETIME YEAR TO SECOND,
                                   p_sortby INT DEFAULT 0,
                                   p_calledNumber LVARCHAR(4000) DEFAULT 'NULL',
                                   p_callingNumber LVARCHAR(4000) DEFAULT 'NULL',
                                   p_applicationName LVARCHAR(4000) DEFAULT 'NULL',
                                   p_contactType NVARCHAR(100) DEFAULT 'NULL',
                                   p_originatorType NVARCHAR(100) DEFAULT 'NULL',
                                   p_destinationType NVARCHAR(100) DEFAULT 'NULL',
                                   p_resourceName LVARCHAR(4000) DEFAULT 'NULL',
                                   p_csqName LVARCHAR(4000) DEFAULT 'NULL',
                                   p_durationGreaterThanEqualTo INT DEFAULT -1,
                                   p_durationLessThanEqualTo INT DEFAULT -1,
   p_user LVARCHAR(4000) DEFAULT 'NULL')
Priority Summary Activity Reportsp_priority_summarysp_priority_summary (
p_startTime DATETIME YEAR TO FRACTION(3),
p_endTime DATETIME YEAR TO FRACTION(3),
p_sortBy INT,
p_priorityList NVARCHAR(150) DEFAULT 'NULL',
                                        p_offset VARCHAR(20) DEFAULT '0')
Reason Code Report by Agent Groupingsp_reasoncode_agent_groupingsp_reasoncode_agent_grouping (
               p_startTime DATETIME YEAR TO FRACTION(3),
               p_endTime DATETIME YEAR TO FRACTION(3),
               p_intLen INT DEFAULT 0,
               p_sortBy INT DEFAULT 0,
               p_resGroupList LVARCHAR(4000) DEFAULT 'NULL',
               p_agentList LVARCHAR(4000) DEFAULT 'NULL',
               p_skillList LVARCHAR(4000) DEFAULT 'NULL',
               p_teamList LVARCHAR(4000) DEFAULT 'NULL',
               p_reasonLabelList NVARCHAR(200) DEFAULT 'NULL',
                p_user LVARCHAR(4000) DEFAULT 'NULL')
Reason Code Report by Reason Code Groupingsp_reasoncode_reason_groupingsp_reasoncode_reason_grouping (
p_startTime DATETIME YEAR TO FRACTION(3),
                            p_endTime DATETIME YEAR TO FRACTION(3), 
                        p_intLen INT DEFAULT 0,          
    p_sortBy INT DEFAULT 0,
    p_resGroupList LVARCHAR(4000) DEFAULT 'NULL',
    p_agentList LVARCHAR(4000) DEFAULT 'NULL',
    p_skillList LVARCHAR(4000) DEFAULT 'NULL',
    p_teamList LVARCHAR(4000) DEFAULT 'NULL',
    p_reasonLabelList NVARCHAR(200) DEFAULT 'NULL',
                            p_user LVARCHAR(4000) DEFAULT 'NULL')
Traffic Analysissp_ivr_traffic_analysis_cuicsp_ivr_traffic_analysis_cuic (startTime DATETIME YEAR TO SECOND
                                       , endTime DATETIME YEAR TO SECOND
                                       , p_offset varchar(20) default '0' -- No offset from UTC
                                       , sort_by INT DEFAULT 0)

 

ciscoUCCX_spList.xlsx 

ciscoUCCX_spList.txt (Code for Each Function)