[Spce-user] subscriber last seen registered

Daniel Grotti dgrotti at sipwise.com
Mon Dec 23 04:36:39 EST 2019

Hi Matthias,
there is nothing out of the box that keep tracks of last registration.
You can only see if a user is registered or if it is not registered.

To get historical info, you can play with db backup or with log parsing, 
to see when was the last successful REGISTER sent by the user.


Daniel Grotti

Head of Customer Support                     Sipwise GmbH
e: dgrotti at sipwise.com                     Europaring F15
t: +43(0)130120332                A-2345 Brunn Am Gebirge
w: www.sipwise.com   FN: 305595f   FG: LG Wiener Neustadt

On 12/20/19 9:25 PM, Raúl Alexis Betancor Santana wrote:
> You could solve it easy, just after doing a save/update of the register 
> on the location table, you could doit on the routing script, doing a 
> sqlop on other table.
> Take into account that on the newest versions of spce, usr_location its 
> saved on redis, not on mysql. But either way, you could doit with a 
> trigger on the redis side
> ------ Mensaje original------
> *De: *Matthias Hohl
> *Fecha: *vie., 20 dic. 2019 18:47
> *Para: *'Henk';spce-user at lists.sipwise.com;
> *CC: *
> *Asunto:*Re: [Spce-user] subscriber last seen registered
> Hm…
> Thanks henk, but expired registrations are not shown there :/
> It would be nice to see just a flag like “last seen registered” or 
> “never registered” to filter out inactive accounts.
> I will try to investigate more on this…
> Or if anybody has another hint would be nice
> *Von:*Spce-user <spce-user-bounces at lists.sipwise.com> *Im Auftrag von 
> *Henk via Spce-user
> *Gesendet:* Freitag, 20. Dezember 2019 18:26
> *An:* spce-user at lists.sipwise.com
> *Betreff:* Re: [Spce-user] subscriber last seen registered
> Hi Matthias,
> You can try ngcp-usr-location --all --verbose  or  ngcp-kamctl proxy ul show
> but I don't think expired registrations will be kept for a long time. In 
> mysql it's the kamailio.location table, in redis I don't know.
> Regards,
> Henk Plessius
> On 20-Dec-19 17:34, Matthias Hohl wrote:
>     Hello,
>     is there any way to read out via CMD, DB or API if a subscriber is
>     registered and if NO, when the subscriber was last time registered?
>     Thank you
>     Mit freundlichen Grüßen,
>     Matthias Hohl
> -- 
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com

More information about the Spce-user mailing list