CAR reporting ac user Call manager 4.2

Unanswered Question
Aug 19th, 2007

I am trying to provide call reporting for a customer using attendant console.

What I want to provide is:

-call duration

-dropped calls

-# of calls

AC is setup using a pilot point (to start with I can not pull the utilization on this pilot point as you can with normal hunt pilots).

anyone any idea how to go about this?

CAR is installed and accessible, CDRs are written

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
rob.huffman Mon, 08/20/2007 - 09:23

Hi Dennis,

I see why you are having problems with this. Here is some info nicely supplied by Gonz from Cisco Systems;


Enhance CAR to report calls to Pilot Points and Hunt Group Members


CAR does not report on calls to Attendant Console Pilot Points and Attendant Console Hunt Group Members.


CCM Version 3.0 till CCM Version 4.1(3).

(DDTS was filed by the time 4.1(3) wa sthe latest version of CCM)


Use the following SQL Commands instaed. Go to Start > Programs > Microsoft SQL Server > Query Analyzer > Connect using Windows Authentication > Select " CDR " DB from the drop down on the Top Right Hand Side and execute the following queries ...

Select count(*) from CallDetailRecord where callingPartyNumber = 'DN OF PILOT POINT' OR originalCalledPartyNumber = 'DN OF PILOT POINT' OR finalCalledPartyNumber = 'DN OF PILOT POINT'

Select count(*) from CallDetailRecord where callingPartyNumber where lastdirectdn = 'DN OF PILOT POINT'

Sorry man!



This Discussion