[Spce-user] Command to show all unregistered subscribers

Daniel Grotti dgrotti at sipwise.com
Mon Sep 14 03:07:30 EDT 2015


Hi,
not really.
Basically from the value you have in the subscriber table (provisioned
users):

mysql> select count(*) from kamailio.subscriber;

you have to subtract the number of registered users:

mysql> select count(*) from kamailio.location;


Regards,

--
Daniel Grotti
VoIP Engineer


Sipwise GmbH
Europaring F15 | 2345 Brunn am Gebirge, Austria | www.sipwise.com

On 09/14/2015 12:04 AM, Matthias Hohl wrote:
> Hello,
> 
> is there anything like "ngcp-kamctl proxy online" but for see all
> unregistered subsribers?
> 
> I want to see, how much of my subscribers are currently not registered.
> 
> 
> Would be nice, if anybody could tell me that.
> 
> Thanks.
> 
> 
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
> 



More information about the Spce-user mailing list