CDR report for Attendant console Pilot Point

Answered Question
Apr 6th, 2007

Does anyone know how to get a CDR report that shows the number of calls into the Attendant console pilot point? Call Manager 4.2.

Thanks in advance.

I have this problem too.
0 votes
Correct Answer by gogasca about 9 years 9 months ago

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'

Unfortunately there is no ETA for a solution yet

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
gogasca Fri, 04/06/2007 - 16:39

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'

Unfortunately there is no ETA for a solution yet

Actions

This Discussion