Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Attention: The Community will be in read-only mode on 12/14/2017 from 12:00 am pacific to 11:30 am.

During this time you will only be able to see content. Other interactions such as posting, replying to questions, or marking content as helpful will be disabled for few hours.

We apologize for the inconvenience while we perform important updates to the Community.

New Member

ICM Custom reporting - Agentwise reports

Hi,

We've got a client running on ICM 7.2. Customer has got some 20-30 dealers spread across country and I've created a call type for each dealer, so that we can check call type reports. Now, they want one to one reports based on relation between agent and calltype i.e. I would like to know if we can report how many times calls from a particular calltype was handled by a particular agent and how long this agent has spent on this calltype. Pls suggest which reports and fields can be used to generate a custom report for this.

Regards,

Soman Nair.

3 REPLIES
Cisco Employee

Re: ICM Custom reporting - Agentwise reports

Hi Soman,

you might need to join separate tables elements, this truly goes in the customisation side of the product, I suggest you sign for a dev support contract to help you assess the challenges coming from the outlined scenario.

Regards,

Riccardo

New Member

Re: ICM Custom reporting - Agentwise reports

Thank you Riccardo. I'd be keen to know which field/s can be used as key to relate data from diff table to use join query. Also, if any of existing report can be used as a template to kick off with.

Regards,

Soman.

Green

Re: ICM Custom reporting - Agentwise reports

At the end of the day, all the information you need is in the Termination_Call_Detail table. It will tie together the call type and the agent.

This data needs to be offloaded from the HDS database to another database server, not running any ICM components. As Cisco say:

"This table can become very large. Running custom reporting queries against it while it is on the HDS can degrade performance."

Regards,

Geoff

165
Views
0
Helpful
3
Replies
CreatePlease to create content