<div dir="ltr">Hi Alex<div>Sounds good, thanks for the input so far, anyway I can add the useragent to the entry ?</div><div>Regards<br><br><div class="gmail_quote">On Wed, Sep 5, 2012 at 2:49 PM, Alex Balashov <span dir="ltr"><<a href="mailto:abalashov@evaristesys.com" target="_blank">abalashov@evaristesys.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Ali,<div><div class="h5"><br>
<br>
On 09/05/2012 07:18 AM, Ali Jawad wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Is it possible to store user logon/logout dates + user agent used. I<br>
know that the info is in the location table but it is not persistent,<br>
and I am using the accounting table to store calls. But I am not sure<br>
there is a way to store logon/logout/user agent.<br>
</blockquote>
<br></div></div>
By "logon" and "logout" I assume you are referring to registration, not something else.<br>
<br>
You can capture a REGISTER request in the main request route and call a SQL operation via 'sqlops' to store that timestamp ($Ts) wherever you want.<br>
<br>
There is no such thing as an "unregistration", technically, just a REGISTER request with an ;expires=0 parameter in the Contact header, or an Expires: 0 header. If you look for those parameters in your processing of the REGISTER request, e.g.<br>
<br>
if((is_present_hf("Expires") && $hdr(Expires) == "0") ||<br>
$hdr(Contact) =~ "expires=0")<br>
<br>
you can store those times, too.<br>
<br>
-- Alex<br>
<br>
-- <br>
Alex Balashov - Principal<br>
Evariste Systems LLC<br>
235 E Ponce de Leon Ave<br>
Suite 106<br>
Decatur, GA 30030<br>
Tel: +1-678-954-0670<br>
Fax: +1-404-961-1892<br>
Web: <a href="http://www.evaristesys.com/" target="_blank">http://www.evaristesys.com/</a>, <a href="http://www.alexbalashov.com/" target="_blank">http://www.alexbalashov.com/</a><br>
<br>
______________________________<u></u>_________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/<u></u>cgi-bin/mailman/listinfo/sr-<u></u>users</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><font><font color="#888888"><b>Ali Jawad <br></b></font></font><div><div><font><font color="#888888"><b>Information Systems Manager<br><font size="1">CISSP - ITIL V3 - RHCE - VCP - C|EH - CCNA - MCSA</font><br>
</b></font></font></div><div><font><font color="#888888"><b>Splendor Telecom <span style="background-color:rgb(255,255,255)">(</span><span style="background-color:rgb(51,51,255);color:rgb(51,102,255)"><a href="http://www.splendor.net/" target="_blank"><span style="background-color:rgb(255,255,255)"><font color="#3366ff">www.splendor.net</font></span></a></span><span style="background-color:rgb(255,255,255)">)</span><br>
Beirut, Lebanon<br>Phone: +9611373725/ext 116<br>FAX: +9611375554<br><br></b></font></font><div><div></div></div></div></div></div><br>
</div></div>