Pulling a CDR report on a number called (CCM 3.3)

[arthurbecker]

I need to pull a CDR report on a number taht keeps getting calls from here but do not know how has been placing them. I'm in the CDR Analysis and Reporting. I've looked around, but which one is the one that I want to use?

Thanks..

[Jaime Valencia]

Configuring CDR Search by User Extension

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/3_3_3/ccmsrva/sacar6.html#wp1036756

Names are pretty self-explanatory, best thing to do is fool around with the tool to see what each reports does.

search is only by called number, not calling

HTH

java

if this helps, please rate

[arthurbecker]

I don't know which extension is calling the number. I'm trying to find out which extension(s) is calling this number as well at what times.

[Jaime Valencia]

go to the phone, directories missed/received/placed calls

HTH

java

if this helps, please rate

[arthurbecker]

I'm looking at over 200 phones and the span is for over a month. i cannot physically do this. That is why I'm looking to run the CDR report in the 1st place.

[bsieber39]

use SQL inside the server that is storing your CDR records:

here is a sample--it works for call manager 4 and up so not sure about 3 but maybe:

DECLARE @StartDateTime DATETIME

,@EndDateTime DATETIME

SELECT @StartDateTime = '03/11/2008 08:00'

SELECT @EndDateTime = '03/11/2008 18:00'

select callingPartyNumber,originalCalledPartyNumber,finalCalledPartyNumber,globalCallID_callId,

duration,origCalledPartyRedirectReason,lastRedirectRedirectReason,

datetimeorigination = DATEADD(hour,-4,(dateadd(second ,dateTimeOrigination, '1/1/1970')))

,datetimedisconnect = DATEADD(hour,-4,(dateadd(second ,dateTimedisconnect, '1/1/1970')))

from calldetailrecord

where originalCalledPartyNumber = ('XXXX')

AND DATEADD(hour,-4,(dateadd(second ,dateTimeOrigination, '1/1/1970'))) >= @StartDateTime

AND DATEADD(hour,-4,(dateadd(second ,dateTimeOrigination, '1/1/1970'))) <= @EndDateTime