[Freeswitch-users] Freswitch ODBC tables

[Gregor Nanger]

And for the record if someone will search. FS on linux, sofia via odbc on
MS SQL server 2008 and it works ok.

Gregor


2012/5/23 Gregor Nanger <gregor at infomedia.si>

> Thank you guys!
>
> Just wanted to figure it out. I wanted to get status of extension
> (registered, oncall, ringing). And I can do this with registrations,
> channels  and calls table. As I searched, I didn't find better way to do
> this from external application. There are also no API command to show
> exactly what I wanted.
>
> Gregor
>
>
>
>
> 2012/5/23 Peter Olsson <peter.olsson at visionutveckling.se>
>
>>  I don’t think there is much documentation about this – since it’s
>> mostly data used internally by FS.****
>>
>> ** **
>>
>> What do you want to do more specifically? I guess most of the tables are
>> quite self-explaining by their names..****
>>
>> ** **
>>
>> /Peter****
>>
>> ** **
>>
>> ** **
>>
>> *Från:* freeswitch-users-bounces at lists.freeswitch.org [mailto:
>> freeswitch-users-bounces at lists.freeswitch.org] *För *Gregor Nanger
>> *Skickat:* den 23 maj 2012 09:13
>> *Till:* FreeSWITCH Users Help
>> *Ämne:* Re: [Freeswitch-users] Freswitch ODBC tables****
>>
>> ** **
>>
>> Please give me hint what to search :-(
>>
>> I tried ODBC tables, sip_registration table, sofia tables, sofia ODBC and
>> tables are mentioned, but no single description for what tables are  used.
>> I figure it out that in registration table are stored active sip
>> registrations with expire date etc..., sip_registration tables has same
>> information, but with more fields.
>>
>> In channels table are stored all legs information when call is active...
>>
>> In Calls are stored active calls when bridge happened between legs...
>>
>> Can you give me a hand for other tables?
>>
>> ****
>>
>> 2012/5/23 Gregor Nanger <gregor at infomedia.si>****
>>
>> Ok Brian, you got me
>>
>> thank you...****
>>
>>
>>
>>
>> ****
>>
>> 2012/5/23 Brian Foster <bdfoster at endigotech.com>****
>>
>> All over the wiki, my friend.****
>>
>> -BDF****
>>
>> On May 22, 2012 6:07 PM, "Gregor Nanger" <gregor at infomedia.si> wrote:****
>>
>>  Hi!
>>
>> I have FS in linux and  moved sofia db via ODBC to MS Sql server and it
>> works ok.
>>
>> Are there any documentation about tables and how they are used by sofia?
>>
>> Thanx, Gregor****
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> 
>> 
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.cluecon.com
>>
>> Join Us At ClueCon - Aug 7-9, 2012
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at 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 at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> 
>> 
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.cluecon.com
>>
>> Join Us At ClueCon - Aug 7-9, 2012
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org****
>>
>> ** **
>>
>>
>> !DSPAM:4fbc8cbd32761286258325! ****
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> 
>> 
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.cluecon.com
>>
>> Join Us At ClueCon - Aug 7-9, 2012
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120523/ab7ff750/attachment-0001.html