Re: [Freeswitch-users] How to check Sofia status

2009-04-23 Thread Raul Fragoso
The simplest way to find if the extension is already on a call is to
check the sip_dialogs table (by default it's stored in a sqlite database
in db/sofia_reg_internal.db, but you can set the sofia profile to use
ODBC and store the tables in another DBMS, like MySQL, PostgreSQL, etc).
The following SQL query will return at least one record if the extension
1000 is on a call:
select * from sip_dialogs where contact_user = '1000';
Otherwise no records will be returned.

Regards,

Raul

On Thu, 2009-04-23 at 11:08 +0530, Baskar wrote:
 Hi,
 
 Michael Collins: I will explain in Detail
 
 If the agent register 1000 in xlite.
 
 The registered users can be viewed by api command api sofia status
 profile default.
 
 After that if i want to view the status of that extension 1000 whether
 he is in calling are in ideal.
 
 There is any api command to check the status of the extension(1000).
 
 Thanks with Advance.
 
 
 -- 
 Warm Regards,
 N.Baskar
 
 ___
 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


___
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


Re: [Freeswitch-users] How to check Sofia status

2009-04-23 Thread Baskar
Hi,
Raul Fragoso:*I can to get that through Mysql DB but i want to know whether
there is any **api command to check the status of the extension(1000).*

*If the agent register 1000 in xlite.

The registered users can be viewed by api command api sofia status profile
default.

After that if i want to view the status of that extension 1000 whether he is
in calling are in ideal.
*
*There is any api command to check the status of the extension(1000).

Thanks with Advance.*

*
-- 
Warm Regards,
N.Baskar
*
___
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


Re: [Freeswitch-users] How to check Sofia status

2009-04-23 Thread Michael Collins
None that I'm aware of. You'll probably have to parse the results of show
channels and search through the name field results. For example, here's a
call I just made from a SIP phone to :

freeswi...@internal show channels
uuid,direction,created,created_epoch,name,state,cid_name,cid_num,ip_addr,dest,application,application_data,dialplan,context,read_codec,read_rate,write_codec,write_rate
53a62ebd-156c-4684-b616-740d7a5b609b,inbound,2009-04-23
11:14:09,1240510449,sofia/internal/1...@10.15.0.91
,CS_EXECUTE,Mikey,1000,10.15.0.213,,playback,local_stream://moh,XML,default,PCMU,8000,PCMU,8000

In this case, name contains sofia/internal/1...@10.15.0.91. From there
you should be able to determine if that is one of the SIP clients whose
status you want to see.

-MC

On Thu, Apr 23, 2009 at 1:30 AM, Baskar yudha2...@gmail.com wrote:

 Hi,
 Raul Fragoso:*I can to get that through Mysql DB but i want to know
 whether there is any **api command to check the status of the
 extension(1000).*


 *If the agent register 1000 in xlite.

 The registered users can be viewed by api command api sofia status profile
 default.

 After that if i want to view the status of that extension 1000 whether he
 is in calling are in ideal.
 *
 *There is any api command to check the status of the extension(1000).

 Thanks with Advance.*

 *
 --
 Warm Regards,
 N.Baskar
 *

 ___
 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


___
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


Re: [Freeswitch-users] How to check Sofia status

2009-04-22 Thread Michael Collins
Could you add some more details to this question? I'm not sure I understand
what you mean...

Thanks,
MC

On Wed, Apr 22, 2009 at 12:58 AM, Baskar yudha2...@gmail.com wrote:

 Hi,

 There is any api command to check the status of the extension whether the
 agent is in ideal or in calling .

 Can any one asset me to solve the problem. Thanks in advance




 --
 Warm Regards,
 N.Baskar


 ___
 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


___
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


Re: [Freeswitch-users] How to check Sofia status

2009-04-22 Thread Dan Le
I think he's asking if there's a way to check the status of a registered
user; if the user is idle versus in a call.
On Wed, Apr 22, 2009 at 12:38 PM, Michael Collins m...@freeswitch.orgwrote:

 Could you add some more details to this question? I'm not sure I understand
 what you mean...

 Thanks,
 MC

 On Wed, Apr 22, 2009 at 12:58 AM, Baskar yudha2...@gmail.com wrote:

 Hi,

 There is any api command to check the status of the extension whether the
 agent is in ideal or in calling .

 Can any one asset me to solve the problem. Thanks in advance




 --
 Warm Regards,
 N.Baskar


 ___
 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



 ___
 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


___
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


Re: [Freeswitch-users] How to check Sofia status

2009-04-22 Thread Baskar
*Hi,

Michael Collins: I will explain in Detail

If the agent register 1000 in xlite.

The registered users can be viewed by api command api sofia status profile
default.

After that if i want to view the status of that extension 1000 whether he is
in calling are in ideal.
*
*There is any api command to check the status of the extension(1000).

Thanks with Advance.


-- 
Warm Regards,
N.Baskar
*
___
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