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 <geo...@ezuce.com> wrote: > On Thu, Oct 28, 2010 at 11:36 PM, Michael Scheidell > <michael.scheid...@secnap.com> 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 > sipx-users@list.sipfoundry.org > List Archive: http://list.sipfoundry.org/archive/sipx-users/ > -- ====================== Tony Graziano, Manager Telephone: 434.984.8430 sip: tgrazi...@voice.myitdepartment.net Fax: 434.326.5325 Email: tgrazi...@myitdepartment.net LAN/Telephony/Security and Control Systems Helpdesk: Telephone: 434.984.8426 sip: helpd...@voice.myitdepartment.net Helpdesk Contract Customers: http://support.myitdepartment.net
_______________________________________________ sipx-users mailing list sipx-users@list.sipfoundry.org List Archive: http://list.sipfoundry.org/archive/sipx-users/