cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

AMA-CUCM Troubleshooting: Best Practices for Reading Trace Files

250
Views
0
Helpful
2
Replies
Highlighted

CCX reporting Date time format extract CCDR report

Can someone please explain how I can change the date/time format in the CCDR report when I export the data to an SFTP location?

 

I get:

Node ID - Session ID - Sequence Number,Start Time,End Time,Contact\Type,Contact\Disposition,Originator\Type,Originator\ID,Originator\Directory Number,Destination\Type,Destination\ID,Destination\Directory Number,Called Number,Original Called Number,Application Name,Queue Time,Talk Time,Hold Time,Work Time

1-479000083644-0,Wed Sep 02 06:55:30 CEST 2015,Wed Sep 02 06:55:34 CEST 2015,1,1,3,,079300155,2,,7011460233,7014457000,7014457000,AE-test,,0,,

 

But I would like to have

1-12000236548-0,2015-06-29 18:34:30.825,2015-06-29 18:34:33.264,1,1,3,,00655794289,2,,50410138,512588809,512588809,Poli-ACD,,0,,

2 REPLIES 2

HiI've done this for a client

Hi

I've done this for a client before - I basically created a custom version of the report which exported the date field as a string rather than a datetime. 

That requires access to CUIC premium and some SQL skills if you have them.

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

Hi Aaron, Good to know... But

Hi Aaron,

 

Good to know... But is is possible to expain me a little bit how? Or to export the custom report so I can import it again?

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards