CDR

[ateeqs.net]

Hi all,

I am new for cdr report, can some one help me, how to pull destination called number cdr report in cisco call manager in which we want to find from which extension calls placed to that destination.

thanks in advance.

A

[kusatija]

Hello,

Assuming that you are using call manager 5.x and above, you can log into the CLI of the publisher and run sql queries.

Lets say the destination called number is 911, you can sure the query:

run sql select  callingpartynumber,originalcalledpartynumber,finalcalledpartynumber,datetimestamporigination from car:tbl_billing_data where originalcalledpartynumber = '911'

Check this support link:

https://supportforums.cisco.com/message/3191806#3191806

I would also suggest you to go through the CDR admin guide for better understanding of CDR data base and functionality.

http://www.cisco.com/en/US/partner/docs/voice_ip_comm/cucm/service/7_1_2/car/carovrvw.html#wp1082064

HTH

Kunal

Please rate helpful posts...