CDR Date & Time conversion

Unanswered Question
Aug 6th, 2008
User Badges:

Hello All,

How can I convert the date & time in the CDR report to underestandable date and time? There used to be a tool for this matter, does anyone have that tool?


Thanks,

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4.7 (3 ratings)
Loading.
mightyking Wed, 08/06/2008 - 12:20
User Badges:

Thanks,

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.


Thanks,

testeven Wed, 08/06/2008 - 12:49
User Badges:
  • Cisco Employee,

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?

mightyking Wed, 08/06/2008 - 15:33
User Badges:

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.

btmulgrew Wed, 08/06/2008 - 15:49
User Badges:

Hi Mightking - you need to ensure the phones are associated with the relevant user (under phone config) to run this report.


Thanks

Brian

mightyking Thu, 08/07/2008 - 04:13
User Badges:

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?


Thanks,

testeven Thu, 08/07/2008 - 09:05
User Badges:
  • Cisco Employee,

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.


Refer to:


http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/4_2_3/ccmsrva/sacar7.html


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

Analyzer


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:


http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/cdr_defs/4_x/cdr413.html

mightyking Thu, 08/07/2008 - 13:07
User Badges:

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.




btmulgrew Thu, 08/07/2008 - 13:30
User Badges:

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


Fabien GILLET Thu, 11/18/2010 - 03:00
User Badges:

Hello,


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.

Firdaush Ginowrie Wed, 05/06/2015 - 08:55
User Badges:

Hello,

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
Regards,

Firdaush

Actions

This Discussion