Good find, George,
While you're at it, maybe also add STS (Site2Site) to the list, I can't
find these records when searching for "To" nor "From or To",
or remove the "callee_route = " statements altogether??? or exclude the
once that are not needed.
I also don't see records with type= "CUSTM" for example.
Other small issue with the CDR list is that the sorting is not done on
what is displayed, 2 examples:
1) External calls without name, but with number should show up at the
beginning or at the end. But they show up between
Simon and Siyum (2 real names overhere) because these calls are sorted as
"sip", based on the sip uri, like :
<sip:00101234...@blabla.some.epo.org>
2) Tandbergs show up on the correct place, but the <From> field is empty
(no name, nada)
In reality the Tandberg sends a <From> field that looks like this:
From: "Name-of-Tandberg"
<sip:blabla.some.epo.org>;tag=a18d82a3fc0ab650
(the Tandbergs only put their name and the sip domain in the From field,
not the complete sip uri.)
Apparently the display routine does not show the Name when there is no
number.
Can this be added to the existing Jira or is a new one needed?
Best regards / Mit freundlichen Grüßen / Sincères salutations
Paul
George Niculae <geo...@ezuce.com> wrote on 03-03-2011 00:07:09:
>
> On Thu, Mar 3, 2011 at 12:17 AM, Kyle Haefner
> <kyle.haef...@colostate.edu> wrote:
> > George,
> >
> > the callee 14272 is an internal user. The caller 16425 is external.
> > the two fields that are different for calls that show up and ones that
> > do not are:
> >
> > callee_contact
> > callee_route
> >
> > Shows up:
> > callee_contact: <sip:14372@x.x.26.255>
> > callee_route: INT
> >
> > does not show up:
> > callee_contact:<sip:1022@x.x.0.13:5060>
> > calee_route:AL,LOCL
>
> See below the sql generated, it looks for calee_route LIKE INT or AA
> or VM or PAGE or PARK. It doesn't search for AL and LCL (alias and
> local call tags) - that's why the 2nd row does not show up. Please
> raise a JIRA. Thanks!
>
> SELECT COUNT(id) FROM cdrs WHERE (? <= start_time) AND (start_time <=
> ?) AND (callee_aor LIKE '%<sip:null@%>' AND (callee_route LIKE '%INT'
> OR callee_route LIKE '%AA' OR callee_route LIKE '%VM' OR callee_route
> LIKE '%PAGE' OR callee_route LIKE '%PARK' OR callee_route LIKE '%DPUP'
> OR callee_route IS NULL));
>
> (You can test the correct sql from cli by replacing ? with values and
> adding "OR callee_route LIKE '%ALOR callee_route LIKE '%LCL'.)
>
> George
> _______________________________________________
_______________________________________________
sipx-users mailing list
sipx-users@list.sipfoundry.org
List Archive: http://list.sipfoundry.org/archive/sipx-users/
