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.
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'
Unfortunately there is no ETA for a solution yet