CDR reporting question

Unanswered Question
Apr 16th, 2008
User Badges:

Hello!


I need to generate a basic reporting on CCM (This is not something what will be frequently done but in case a bill for particular month is suspiciously big that some calls can be traced). My question is if it is possible to generate such kind of report if I don't have the users defined, purely extension based.

For example that I can generate last month report for extension "122". Or to check top5 spending extensions.

I hope I'm clear enough



best regards,


goran pilat

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Adam Thompson Wed, 04/16/2008 - 11:16
User Badges:
  • Silver, 250 points or more

Depending on the verison of CCM that you are running and if you have CDR recording turned on, you should be able to pull this information directly out of SQL.


If you ran the query against the CDR database:

select * from CallDetailRecord where callingPartyNumber = '122'


This should give you all of the outgoing calls that this extension made. You can even narrow it down by adding in some time constraints to the query.


Also, you could use CAR if you have that enabled. It will give you a nice GUI to use instead of doing a direct query on the DB.


-Adam

Please rate if helpful

goranpilat Thu, 04/17/2008 - 04:02
User Badges:

Hi guys,,


Version is 4.2(3). I use CAR, and I see that I can see all the calls from particular extension by going to CDR->search->BY user/extension and adding this extension.

Is there a way to see the extensions that had the most spendings the last month? Or any other way which would allow me to see which extension was extremely active last month and produced too big invoice?


Also I see that calls can be classified as onNet, incoming, local, international and so on. As all the outbound calls are classified as "other", where do I have to set e.g. "local" call being the one that starts with "0" and international with "00"


thanks a lot,


goran

Jaime Valencia Thu, 04/17/2008 - 07:17
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    2011

the link that i previously posted contains which reports you can use and what they show, also it's for the version you have


you can see in there which one suits your needs


about the classification there is an option called dial-plan under when you are in CAR to configure how to match calls according to your dial plan


HTH


javalenc


if this helps, please rate

Actions

This Discussion