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. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

CDR By Extension Report - 100 record limit

is there a way to change the 100 record limit for the CDR Extension Report? If it can't be changed how do I get a report with all records for that extension?

1 REPLY

Re: CDR By Extension Report - 100 record limit

That is a simple search of the CDR database; is not really a report and is limited to 100 records and can't be increased AFAIK.

You can use SQL Query Analyzer and query the CDR SQL Database directly.

Sample query for searching on calling party number:

use cdr

select *

from calldetailrecord

where (callingPartyNumber = '1111')

Sample for number called:

use cdr

select *

from calldetailrecord

where (finalcalledpartynumber = '1111')

1111 is extension/number used in samples.

305
Views
0
Helpful
1
Replies