- Bronze, 100 points or more
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 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'