Our core and all other information in mysql database. You mean hashdb is Sqlite? xmlstatus -- how to access from externally? I find sometimes the registration tables have records . but the devices are not connected to freeswitch? What is reliable accurate way to get information in real time? Lloyd * <http://www.sunteltech.ca/blog/>* On Thu, Apr 12, 2012 at 10:59 AM, Mitch Capper <mitch.capper@gmail.com>wrote:

Well using ESL to connect to FS you can then query the hash DB which stores some of those items or use the xml status commands would probably give you the best results.

~Mitch

On Thu, Apr 12, 2012 at 7:30 AM, Lloyd Aloysius <lloyd.aloysius@gmail.com> wrote:

...

Hi All,

I would like to find a better[efficient] way to query freeswitch. I am implementing a dashboard [PHP/Jquery] to view status of freeswitch.Lets assume system is a busy and always 100+ active calls.

I want to know the following info

1. show calls 2. Sofia status 3. show channels etc

What is the better direction to implement this

a. Query Data Base tables

or

b. Event Library

or

?

Thanks in advanced. Lloyd

_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com

Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com

FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org

_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com

Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com

FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org

Many of the status requests now there is an XML option also like "sofia xmlstatus" you can use ESL to do that (see wiki for other commands). Using the events however is better for performance to avoid polling but does obviously require more logic to maintain state. ~Mitch