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?
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,,
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.
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?