CDR by Outbound Dialed Number

[rossporubski]

Hello,

Is it possible to run a report on an outbound dialed number? I have been tasked to find how many times a number has been called. I normally did this with query analyzer with an if statement in older versions of CM but this is on UCM 8.

Any help is greatly appreciated. 

Thank you to all in advance.

[Brian Meade]

You can search CDR records by phone number in the CAR webpage.  Another option would be to pull from the CAR database using SQL queries- http://www.ucguerrilla.com/2012/03/cucm-sql-queries-installment-5.html

[rossporubski]

Hi @ Brian Meade, thank you for your reply.

Are you talking about the CDR Analysis and Reporting page under Tools from Cisco Unified Serviceability page?

Thank you

[Brian Meade]

Yea, that's the same one.  Also referred to as CAR.

[rossporubski]

Ok, I don't see anywhere in any report I can add a physical number 555-555-555 and run it to list all instances of that number being dialed with detail or summary.

Thank you

[Brian Meade]

Under CDR->Search->By Phone Number.  You'll want to add it there.

[rossporubski]

Interesting. I don't have "By Phone Number"

CDR
Search -> By User Extension
                  By Gateway
                  By Cause for Call Termination
                  By Call Precedence Level
                  Malicious Calls

[Brian Meade · Accepted solution]

What version are you on?

Mine shows "By User/Phone Number/SIP URL" for the first option.

You can try using the "By User Extension" option but it may not work.

You can use the CDR->Export CDR function to just export that date range to an Excel sheet and do your filtering there.

The SQL queries would be another option as well.

Brian