[Spce-user] subscriber last seen registered

Raúl Alexis Betancor Santana rabs at dimension-virtual.com
Fri Dec 20 15:25:03 EST 2019

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 HohlFecha: vie., 20 dic. 2019 18:47Para: 'Henk';spce-user at lists.sipwise.com;CC: Asunto:Re: [Spce-user] subscriber last seen registeredHm…

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.


Henk Plessius

On 20-Dec-19 17:34, Matthias Hohl wrote:


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20191220/86ee13ee/attachment-0002.html>

More information about the Spce-user mailing list