CDR By Extension Report - 100 record limit

[mtashiro]

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?

[Erick Bergquist]

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.