Tracking DID Usage Over Time

While I use the CDR, AsterNIC and a few other statistical report systems, does anyone have a good suggestion for tracking DID call totals and minutes usage over time?

Ideally, I would like to be able to quickly figure out which DIDs are used the most for a given period of time (30, 60 90 days, etc.). The purpose is to know when we can retire marketing numbers which no longer get calls, or to be able to identify the specific DIDs which get the most calls, etc.


That would only need a mysql query to suit your needs, The table is asteriskcdrdb and the manual is at

I doubt any one will do that for you for free though, ask your IT department.

There is a POSSA moduleā€¦

I have never used it, but it may get you in the neighborhood