on 02-14-2017 10:46 AM
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 |
Hello Joey,
do you have the list of parameters that these SP take?
Thanks.
Hi Joey,
I was able to retrieve the parameter lists and datatypes for each stored procedure and added them to your list.
Report | Stored Procedure | Procedure Parameters & Data Types |
Abandoned Call Detail Activity | sp_abandoned_calls_activity | sp_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 Detail | sp_aborted_rejected_call_detail | sp_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 Fields | sp_agent_all_fields | sp_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 Summary | sp_agent_call_summary | sp_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 Detail | sp_agent_detail | sp_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 Activity | sp_agent_log_activity | sp_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 Summary | sp_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 Detail | sp_agent_state_detail | sp_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 Agent | sp_agent_state_interval | sp_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 Interval | sp_agent_state_interval | sp_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 Report | sp_agent_summary | sp_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 Summary | sp_agent_wrapup_summary | sp_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 Detail | sp_agent_wrapup_detail | sp_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 Variables | sp_custom_variable | sp_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 Activity | sp_called_number_summary_activity | sp_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 Activity | sp_common_skill_csq_interval | sp_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 CSQ | sp_csq_interval | sp_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 Duration | sp_csq_interval2 | sp_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 Activity | sp_csq_activity | sp_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 Interval | sp_csq_interval | sp_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 Summary | sp_csq_call_distribution | sp_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 Summary | sp_csq_priority_summary | sp_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 Summary | sp_csq_service_level_priority | sp_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 Summary | sp_csq_agent_summary | sp_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 Report | sp_csq_all_fields | sp_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 CCDR | sp_ccdr | sp_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 Agent | sp_call_csq_agent | sp_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 Report | sp_priority_summary | sp_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 Grouping | sp_reasoncode_agent_grouping | sp_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 Grouping | sp_reasoncode_reason_grouping | sp_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 Analysis | sp_ivr_traffic_analysis_cuic | sp_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) |
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: