Ricardo Carvalho wrote: > Is there a way to keep track in Asterisk of which phones are online in > realtime using some MySQL DB table for exemple, much like "sip show > peers" does in the CLI?
If you are using real realtime with rtupdate=yes in sip.conf Asterisk stores the current time + sip registration time in the regseconds column in your sipfriends table (the name depends on your extconfig.conf). So you could do something like SELECT * FROM `sipfriends` WHERE `regseconds` > UNIX_TIMESTAMP() to get a list of the registered SIP friends. Regards, Philipp -- amooma GmbH - Bachstr. 126 - 56566 Neuwied - http://www.amooma.de Let's use IT to solve problems and not to create new ones. Asterisk -> http://www.das-asterisk-buch.de Geschäftsführer: Stefan Wintermeyer Handelsregister: Neuwied B 14998 _______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
