<div dir="ltr"><div>Hi<br><br></div>This would be a useful addition - we constantly get the request from users "why do you not tell us when we are not registered" - so the ability to pick that up and notify them would be great.<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Sep 14, 2015 at 9:07 AM, Daniel Grotti <span dir="ltr"><<a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
not really.<br>
Basically from the value you have in the subscriber table (provisioned<br>
users):<br>
<br>
mysql> select count(*) from kamailio.subscriber;<br>
<br>
you have to subtract the number of registered users:<br>
<br>
mysql> select count(*) from kamailio.location;<br>
<br>
<br>
Regards,<br>
<br>
--<br>
Daniel Grotti<br>
VoIP Engineer<br>
<br>
<br>
Sipwise GmbH<br>
Europaring F15 | 2345 Brunn am Gebirge, Austria | <a href="http://www.sipwise.com" rel="noreferrer" target="_blank">www.sipwise.com</a><br>
<div><div class="h5"><br>
On 09/14/2015 12:04 AM, Matthias Hohl wrote:<br>
> Hello,<br>
><br>
> is there anything like "ngcp-kamctl proxy online" but for see all<br>
> unregistered subsribers?<br>
><br>
> I want to see, how much of my subscribers are currently not registered.<br>
><br>
><br>
> Would be nice, if anybody could tell me that.<br>
><br>
> Thanks.<br>
><br>
><br>
</div></div>> _______________________________________________<br>
> Spce-user mailing list<br>
> <a href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a><br>
> <a href="https://lists.sipwise.com/listinfo/spce-user" rel="noreferrer" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
><br>
_______________________________________________<br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a><br>
<a href="https://lists.sipwise.com/listinfo/spce-user" rel="noreferrer" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
</blockquote></div><br></div>