This is probably a real soft question - sorry if I can't see the woods for the trees.
I'm pulling off various reports via ART and Excel from the Callmanager CDR. However both methods report the times of the calls wrong by exactly one hour (a call made at 11:00 am is reported as 10:00 am) I guess this is to do with time settings on the Callmanager ( which is set to GMT and is correct !!!). The Date/Time group under Callmanager Administration is set to 'Local Time Zone of Callmanager'.
I've had a look through the SQL Enterprise Manager and can find no way to manipulate the CDR time values. Any help would be appreciated.