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

CAR reporting ac user Call manager 4.2

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

Please remember to rate useful posts, by clicking on the stars below.

1 REPLY
Hall of Fame Super Red

Re: CAR reporting ac user Call manager 4.2

Hi Dennis,

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

CSCsd58497

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

Symptom:

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

Conditions:

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)

Workaround:

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!

Rob

108
Views
0
Helpful
1
Replies
CreatePlease to create content