CDR Report with MCR Key

Answered Question
Mar 28th, 2007

Is there a way to tell which phone is picking up the calls on an MCR key? We have 4 phones with the same line appearance on them and are looking for a way to run a report to see which phones are taking the most calls.

I have this problem too.
0 votes
Correct Answer by adhernan about 9 years 8 months ago

I just did the same for our desk the other day. With the following SQL query you can export the results to a spreadsheet. All CDR times are in GMT and you need to convert the timeframe you want into epoch time before running query against CDR database. In this query you would adjust the dateTimeConnect ranges and finalcalledpartynumber at end of string to your timeframe and share DN (in my example begin jan01.2007- march 19 and DN 6700). Hope this helps! -Adam

select callingpartynumber,finalcalledpartynumber,destDeviceName,finalCalledPartyLoginUserID,(select dateadd(second,datetimeconnect,'19700101') as datetimedisconnect),(select dateadd(second,datetimedisconnect,'19700101') as datetimedisconnect) from CallDetailRecord where dateTimeConnect > '1167631200' and datetimeconnect < '1174366800' and finalcalledpartynumber= '6700'

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
adhernan Wed, 03/28/2007 - 08:41

I just did the same for our desk the other day. With the following SQL query you can export the results to a spreadsheet. All CDR times are in GMT and you need to convert the timeframe you want into epoch time before running query against CDR database. In this query you would adjust the dateTimeConnect ranges and finalcalledpartynumber at end of string to your timeframe and share DN (in my example begin jan01.2007- march 19 and DN 6700). Hope this helps! -Adam

select callingpartynumber,finalcalledpartynumber,destDeviceName,finalCalledPartyLoginUserID,(select dateadd(second,datetimeconnect,'19700101') as datetimedisconnect),(select dateadd(second,datetimedisconnect,'19700101') as datetimedisconnect) from CallDetailRecord where dateTimeConnect > '1167631200' and datetimeconnect < '1174366800' and finalcalledpartynumber= '6700'

MikeTomasko Wed, 03/28/2007 - 08:49

Thanks for the quick reply! It looks like you're getting me on the right track, but could you explain the format of the date and times? What would I use for the date and time if I just wanted to see the traffic on that DN for all of yesterday? Thanks!

adhernan Wed, 03/28/2007 - 08:57

If the users had extension mobility you would get that otherwise I got around by using GREP to associate the phone NAME (MAC) with the user assigned to phone. -basically replace device name with user name .. crude but works...

MikeTomasko Wed, 03/28/2007 - 10:26

I think I'm catching on! GREAT info! Now for what's probably an easy question...how do I get the data into Excel?

Actions

This Discussion