How to retrieve a list of recent calls

Version 1
    This document was generated from CDN thread

    Created by: Nate Jacobs on 25-06-2009 06:38:37 PM
    Hello everyone.  Can anyone tell me the best way to retrieve a list of recent phone calls?  It it's best to use a SQL query, which table(s) should I be looking at?
     
    Thanks

    Subject: RE: How to retrieve a list of recent calls
    Replied by: David Staudt on 25-06-2009 08:04:47 PM
    The Call Detail Record (CDR) system is probably what you are looking for.  The normal setup involves configuring an FTP target in the UCM admin, where UCM will deliver all system CDRs every minute (by default.)  The CDRs are in a flat-file, csv format.
     
    If you don't need every single CDR, but are more interested in adhoc access, take a look at the CDRonDemand SOAP API (covered in the AXL docs.)  Via this small API you can query for a list of available CDR files (up to a one hour interval) and request delivery of specific files (to your waiting FTP server.)
     
    Note CDRs are written after a call completes, and are collected from UCM Subscribers every minute (by default) so any very recent calls will not be present.

    Subject: RE: How to retrieve a list of recent calls
    Replied by: Nate Jacobs on 29-06-2009 04:48:14 PM
    Thanks very much, David.
    I didn't specify that I'm looking for a history of Incoming calls.  Would you still recommend CDR?

    Subject: RE: How to retrieve a list of recent calls
    Replied by: David Staudt on 29-06-2009 06:20:50 PM
    Well, you'll get every call made by the same via CDR, so will need to do some filtering.  Based on the various fields in the CDR itself, you can filter for calls just for one phone, and just inbound, if needed - for example via the 'destDeviceName' field, if your app knows the phone's SEPxxxx device name.

    Subject: RE: How to retrieve a list of recent calls
    Replied by: Nate Jacobs on 30-06-2009 05:19:11 PM
    Thank you, David.  You've been very helpful.