How can I export various Asteriks statistics?

asterisk
freepbx
configuration
Tags: #<Tag:0x00007fafc4b74f50> #<Tag:0x00007fafc4b74de8> #<Tag:0x00007fafc4b74ca8>

(Dexterviora) #1

Hi I’m new into this field so sorry if it sounds too obvious.
Saying “various” I mean

  • Average number of daily incoming and outgoing calls

  • Number of saved call recordings

  • Number of active telephony users

  • The number of average active telephony calls in work hours.

Can I export something like this?
Current Free PBX version installed is 13.0.190.19


(Dave Burgess) #2

Not without some more commercial modules, but if you know anything about MySQL (or the Maria variant) you can create your own reports using the data from the ‘asteriskcdrdb’ database and the ‘cdr’ table.

The cdr database table has all of the raw information you could need. The only thing that might get jinky is if you wanted to know the number of simultaneous calls.