[Spce-user] Command to show all unregistered subscribers

[Theo]

Hi

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.

On Mon, Sep 14, 2015 at 9:07 AM, Daniel Grotti <dgrotti at sipwise.com> wrote:

> 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
> >
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20150914/b1f49559/attachment-0001.html>