[cisco-voip] Can You Obtain INCOMING Call Reports (CDR) from the Call Manager?

[Ed Leatherman]

Hi Steve,

Yes you can. Might be able to do it with CAR but I dont use that unless I
must. You can use the MS SQL query analyzer on the publisher to generate all
kinds of useful information;

Load up the Query Analyzer from the start menu, use local authentication.
Select the CDR database from the dropdown at the top.

Query I like to use and modify (I think I got this one from Wes)

SELECT DATEADD(ss, datetimeorigination, 'Jan 1, 1970 00:00:00')
   AS datetime, callingPartyNumber, originalcalledpartynumber,
   finalcalledpartynumber, duration, origdevicename, destdevicename
FROM calldetailrecord
WHERE callingPartyNumber = '39811'
ORDER BY datetimeorigination

Off the top of my head, you could search based on
WHERE origdevicename = 'yourgatewaynamehere'  OR origdevicename =
'yourothergatewaynamehere'
to get incoming calls (or there might be an better way)

Timestamps in the results are in GMT with that sql query.

Ed

On 1/29/07, Miller, Steve <MillerS at dicksteinshapiro.com> wrote:
>
>  All I see are outgoing when I run a department billing report.  Please
> help!
>
>


-- 
Ed Leatherman
Senior Voice Engineer
West Virginia University
Telecommunications and Network Operations
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20070129/4c23a5a7/attachment.html