On Thu, Oct 28, 2010 at 11:36 PM, Michael Scheidell <[email protected]> wrote: > trying to look up (a spam caller) who has called several of our DID's > > tried to use the 'From' drop down field. > put in the number (nothing shows up) put in the CNAM, nothing shows up, put > in (it is appears on CIDR report) CNAM - number > nothing shows up. > > yes, if I select 'all' for same period, it shows up as: > PORTFOLIO RECOV - 6206628870 > > so, in the 'from' field in historic CIDR report, what to I put in to see who > else that caller has called? >
Don't think this will work as it seems FROM applies for internal extensions only - so if you query after with PORTFOLIO as FROM, generated sql will look something like: SELECT COUNT(id) FROM cdrs WHERE (? <= start_time) AND (start_time <= ?) AND (caller_aor LIKE '%<sip:portfo...@%>' AND caller_internal=true) Can you directly access CDR db and perform a query? George _______________________________________________ sipx-users mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-users/
