<html xmlns="http://www.w3.org/TR/REC-html40"><head><style><!--
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI Emoji";
panose-1:2 11 5 2 4 2 4 2 2 3;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:DE-AT;}
span.E-MailFormatvorlage19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.E-MailFormatvorlage20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style></head><body lang="DE-AT"><SPAN style="font-size: 11pt"><html><head>
</head>
<body style="margin-bottom:45px">
<div style="font-size: 10pt;"><div dir="ltr" style="margin-top:0;margin-bottom:0;">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.</div><div dir="ltr" style="margin-top:0;margin-bottom:0;"><br></div><div dir="ltr" style="margin-top:0;margin-bottom:0;">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</div></div>
<div style="font-size: 10pt;"><div dir="auto" style="margin-top:0;margin-bottom:0;"><br></div><div dir="auto" style="margin-top:0;margin-bottom:0;">------ Mensaje original------</div><div dir="auto" style="margin-top:0;margin-bottom:0;"><b>De: </b>Matthias Hohl<matthias.hohl@telematica.at></matthias.hohl@telematica.at></div><div dir="auto" style="margin-top:0;margin-bottom:0;"><b>Fecha: </b>vie., 20 dic. 2019 18:47</div><div dir="auto" style="margin-top:0;margin-bottom:0;"><b>Para: </b>'Henk';spce-user@lists.sipwise.com;</div><div dir="auto" style="margin-top:0;margin-bottom:0;"><b>CC: </b></div><div dir="auto" style="margin-top:0;margin-bottom:0;"><b>Asunto:</b>Re: [Spce-user] subscriber last seen registered</div><div dir="auto" style="margin-top:0;margin-bottom:0;"><br></div></div></body></html></SPAN><div class="WordSection1"><p class="MsoNormal"><span lang="EN-US">Hm…</span></p><p class="MsoNormal"><span lang="EN-US"> </span></p><p class="MsoNormal"><span lang="EN-US">Thanks henk, but expired registrations are not shown there :/</span></p><p class="MsoNormal"><span lang="EN-US"> </span></p><p class="MsoNormal"><span lang="EN-US">It would be nice to see just a flag like “last seen registered” or “never registered” to filter out inactive accounts.</span></p><p class="MsoNormal"><span lang="EN-US">I will try to investigate more on this…</span></p><p class="MsoNormal"><span lang="EN-US"> </span></p><p class="MsoNormal"><span lang="EN-US">Or if anybody has another hint </span><span lang="EN-US" style="font-family:"Segoe UI Emoji",sans-serif"></span><span lang="EN-US"> would be nice</span></p><p class="MsoNormal"><span lang="EN-US"> </span></p><p class="MsoNormal"><span lang="EN-US"> </span></p><div><div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span lang="DE" style="mso-fareast-language:DE-AT">Von:</span></b><span lang="DE" style="mso-fareast-language:DE-AT"> Spce-user <spce-user-bounces@lists.sipwise.com> <b>Im Auftrag von </b>Henk via Spce-user<br><b>Gesendet:</b> Freitag, 20. Dezember 2019 18:26<br><b>An:</b> spce-user@lists.sipwise.com<br><b>Betreff:</b> Re: [Spce-user] subscriber last seen registered</span></p></div></div><p class="MsoNormal"> </p><p>Hi Matthias,<span style="mso-fareast-language:DE-AT"></span></p><p class="MsoNormal">You can try ngcp-usr-location --all --verbose or ngcp-kamctl proxy ul show<br>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.</p><p>Regards,</p><p>Henk Plessius</p><div><p class="MsoNormal">On 20-Dec-19 17:34, Matthias Hohl wrote:</p></div><blockquote style="margin-top:5.0pt;margin-bottom:5.0pt"><p class="MsoNormal">Hello,</p><p class="MsoNormal"> </p><p class="MsoNormal"><span lang="EN-US">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?</span></p><p class="MsoNormal"><span lang="EN-US"> </span></p><p class="MsoNormal"><span lang="EN-US">Thank you</span></p><p class="MsoNormal"><span lang="EN-US"> </span></p><p class="MsoNormal"><span style="mso-fareast-language:DE-AT">Mit freundlichen Grüßen,</span></p><p class="MsoNormal"><span style="mso-fareast-language:DE-AT">Matthias Hohl</span></p><p class="MsoNormal"><span style="mso-fareast-language:DE-AT"> </span></p><p class="MsoNormal"><span style="mso-fareast-language:DE-AT"> </span></p><p class="MsoNormal"> </p><p class="MsoNormal"><span style="mso-fareast-language:DE-AT"><br><br></span></p></blockquote></div><BR><BR>--
<br>Spce-user mailing list
<br>Spce-user@lists.sipwise.com
<br>http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com
<br></body></html>