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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

CDR report for Attendant console Pilot Point

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Green

Re: CDR report for Attendant console Pilot Point

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

2 REPLIES
Green

Re: CDR report for Attendant console Pilot Point

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

New Member

Re: CDR report for Attendant console Pilot Point

Thanks you very much.

212
Views
0
Helpful
2
Replies
CreatePlease login to create content