[asterisk-dev] realtime device status and channels in database

[François Delawarde]

Hello,

I would like to know what is the best way to export realtime monitoring
of active channels and device status in a db (sqlite3 or similar).

It is to be used in several applications sharing those informations (web
apps displaying realtime status, daemons sending alarms, ...).

As far as I know, possibilities are:

- using AMI events and commands: Events don't provide enough information
about device status (channel codec/variables, dahdi hook status, ...).
Also if monitoring daemon crashes or is restarted, events might be lost
so it cannot be only based on events. In that case, one should use
CoreShowChannels, SipShowPeers, and similar commands every second or so
to refresh current status. Is this recommended? Wouldn't this eat lots
of resources?

- using CLI: Very dificult / Impossible to parse.

- using log file: Difficult to parse, need to incorporate NoOps to have
aditional info, need initial status from elsewhere to compute current
channel status...


Is there an easy and robust way of exporting realtime events and/or
device status / active channels in a database using an external
application?

What about developping an Asterisk module providing realtime channel
information and device status in sqlite3 db? Is this even possible, easy
enough to do?

Thanks,
François.