[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.
Cheers,
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