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

Cisco CDR Report by duration

Is there a way that we can pull the report for the duration of the calls not the number of calls?

I am trying to pull the report so we can set an invoice to certain department for their use. But currently, the Cisco CDR only let me pull the number of calls not include the duration of the calls.

Yes, there is an option to pull Top N user based on the duration but I can not specify certain Ext. / group.

Also, is there any recommended 3rd party CDR report software that is not expensive for Cisco CallManager 6.1

Thanks,

sienz

4 REPLIES
Community Member

Re: Cisco CDR Report by duration

With 6.1 you can run a SQL query against the CDR for just about any field you want. Attached is a query I came up to look for calls > 600 seconds; you can change the number to be anything.

You can also use 3rd party vendors, the only one I have looked at briefly is Syn-Apps. HTH's

Community Member

Re: Cisco CDR Report by duration

do that by telnet/ssh into PUB IP address.

Community Member

Re: Cisco CDR Report by duration

Thanks,

This is a cool script. but I may not be able to get the exact minutes that they are using for certain numbers so we can charge this group for billing.

Another questions, what is the max CDR that we can store in the CUCM without compromising the HD size?

Community Member

Re: Cisco CDR Report by duration

John,

thanks for that example...I was looking for the table to query for CDR for a while now..

would you know if there is a way to export the output to a text file as part of the command...or to create a connected from sql

currently I use putty to log the output to a file and then to get it to excel and format it is a lot of steps...

thanks,

:JoeL

227
Views
4
Helpful
4
Replies
CreatePlease to create content