but if you want instant karma, just do the report>call hostory and download to csv or whatever and parse however you need to get the information you need now.
On Thu, Oct 28, 2010 at 6:17 PM, George Niculae <[email protected]> wrote: > 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/ > -- ====================== Tony Graziano, Manager Telephone: 434.984.8430 sip: [email protected] Fax: 434.326.5325 Email: [email protected] LAN/Telephony/Security and Control Systems Helpdesk: Telephone: 434.984.8426 sip: [email protected] Helpdesk Contract Customers: http://support.myitdepartment.net
_______________________________________________ sipx-users mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-users/
