CDR report for Attendant console Pilot Point

Answered Question
Apr 6th, 2007
User Badges:

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.

Correct Answer by gogasca about 10 years 2 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
User Badges:
  • Green, 3000 points or more

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