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

Unanswered Question
Nov 14th, 2008
User Badges:

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..

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
arthurbecker Fri, 11/14/2008 - 10:50
User Badges:

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 Fri, 11/14/2008 - 10:53
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    2011

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


HTH


java


if this helps, please rate

arthurbecker Fri, 11/14/2008 - 11:00
User Badges:

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 Fri, 11/14/2008 - 11:45
User Badges:

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

Actions

This Discussion