CDR report for Attendant console Pilot Point

[chadrhayes]

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.

[gogasca · Accepted solution]

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

[chadrhayes]

Thanks you very much.