Re: [SR-Users] User accounting

Sure, just pull it out with the $ua or $hdr(User-Agent) PVs.

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

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 mailto: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 <mailto:sr-users@lists.sip-router.org>
http://lists.sip-router.org/__cgi-bin/mailman/listinfo/sr-__users
<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 http://www.splendor.net/) Beirut, Lebanon Phone: +9611373725/ext 116 FAX: +9611375554

---

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