Hi Alex
Sounds good, thanks for the input so far, anyway I can add the useragent to the entry ?
Regards

On Wed, Sep 5, 2012 at 2:49 PM, Alex Balashov <abalashov@evaristesys.com> wrote:
Hi Ali,


On 09/05/2012 07:18 AM, Ali Jawad wrote:

Is it possible to store user logon/logout dates + user agent used. I
know that the info is in the location table but it is not persistent,
and I am using the accounting table to store calls. But I am not sure
there is a way to store logon/logout/user agent.

By "logon" and "logout" I assume you are referring to registration, not something else.

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.

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.

   if((is_present_hf("Expires") && $hdr(Expires) == "0") ||
      $hdr(Contact) =~ "expires=0")

you can store those times, too.

-- Alex

--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users



--
Ali Jawad   
Information Systems Manager
CISSP - ITIL V3 - RHCE - VCP - C|EH - CCNA - MCSA
Splendor Telecom (www.splendor.net)
Beirut, Lebanon
Phone: +9611373725/ext 116
FAX: +9611375554