Check this link:
On the "Date Format in the CDR Database" section there's a link you can click to download the tool and it explains how to convert the time using excel too :)
I am not able to retieve the CDR repport by selecting the user. It shows nothing in the output but when I chose "Department" I can see the details. Although I see the CSV format but the only working option is the PDF. I am using CCM 5.1. Please let me know if I am missing something.
Are you getting any error message?
I guess you are using the User Reports--> Individual, can you please try running a report from: CDR--> Search--> User/Extension and see if this works?
I can get the output from CDR--> Search--> User/Extension but how can I export that file. The only available option is "send report" but normaly the CCM is not configured to send any emails.
Hi Mightking - you need to ensure the phones are associated with the relevant user (under phone config) to run this report.
I have the output but don't know how to export them. The only option I have is to send report but the CCM is not configured to send emails. Is there any other ways?
If you don't want to send the report by e-mail you can go to CDR > Export CDR/CMR, but this will export all of them not only for one extension.
Otherwise if this is a CCM 4.X you can run a SQL query for that extension.
Publisher Call Manager>Start>Programs>MS SQL Server >Query
Select the appropriate database from the DB: dropdown menu, then
type the following in the blank area:
From the query analyzer run the following command:
"select * from CallDetailRecord where
callingPartyNumber = XXXX"
This link explains the CDR record fields:
If you still need a time conversion method, here is the link I use:
Or you can use this formula in excel for EST conversion: (where C5 is the cell you put the unix format date/time in)
I am looking for how to export the output from CDR--> Search--> User/Extension. The only available option is "send report" but normaly the CCM is not configured to send any emails. I am using CCM 5.1.
You can export a CDR dump for a specific date using:
Step 1 From CDR Analysis and Reporting, choose CDR > Export CDR/CMR.
The Export CDR/CMR records window displays.
Step 2 In the From Date and To Date pull-down menus, choose a date range for the CDR/CMR dump.
Step 3 In Select records, check the CDR and/or CMR check box.
Step 4 Click Export to File.
from the CUCM 5.X CDR Admin Guide
Altenatively configure the email paramaters in CUCM and email your "CDR search by extension" to the relevant recipient
I need confirmation about the date in CDR. The format of the date is in UTC time whatever the date format of the windows system ?
Because in my CUCM in version 4.2 i have one hour shift between the time of call and the time in the CDR for the same call.
Could you give me the link in the Cisco documentation that's explain this ?
Thanks in advance for your answer.
you can translate the timestamp with this method:
1.Put the timestamp in cell a1.
2.In cell a2, enter =a1/86400+25569.
3.To apply a new format to this cell, right-click and choose Format cells >
Numbers > Custom. In the Type field, enter dd:mmm:yyyy hh:mm.
The output looks like this: 04 Apr 2001, 13:57