« Back to Call Detail Records Questions

RE: CDR Time Question

Combination View Flat View Tree View
Threads [ Previous | Next ]
CDR Time Question
cdr timestamp cdr reporting
Answer
8/24/12 8:44 PM
Could you please help with the numbers in the CDR filename, and, within the file itself (dateTimeOrigination field for e.g.)
 
CUCM 8 and FTP server is US central time
FTP server is running Windows 2008 standard sp2
 
This is a list of most recent files on the FTP server that's getting those files, as shown in Windows Explorer from a Windows 7.
 
cdr_StandAloneCluster_01_201208241914_283267 - created aug-24-2012 9:14 am
cdr_StandAloneCluster_02_201208241914_257869 - created aug-24-2012 9:14 am
cmr_StandAloneCluster_02_201208241914_257869 - created aug-24-2012 9:14 am
 
What does 1914 mean in the filenames?
What do the numbers after the underscore mean in the filename?
 
example dateTimeOrigination value: 1345835481
Which format is the value in and how do I translate this value back in human readable value?
 
 
Flag

RE: CDR Time Question
Answer
8/27/12 7:33 PM as a reply to Shivinder Singh.
Hi,
Found out that the dateTimeOrigination and similar time values are in UNIX epoch time format.
To convert to local time using C#:
http://virtuoso217.blogspot.com/2012/08/converting-timestamp-to-datetime-c.html#!/2012/08/converting-timestamp-to-datetime-c.html
Flag

RE: CDR Time Question
Answer
12/3/12 3:50 PM as a reply to Shivinder Singh.
For anyone who comes across this post, this if from Cisco Unified Communications Manager Call Detail Records Administration Guide 8.0:
Filename Format
The following example shows the full format of the filename:
tag_clusterId_nodeId_datetime_seqNumber
• tag—Identifies the type of file, either CDR or CMR.
• clusterId—Identifies the cluster or server where the Cisco Unified Communications Manager
database resides.
• nodeId—Identifies the node
• datetime—UTC time in yyyymmddhhmm format
• seqnumber—Sequence number
Flag