We are experiencing some strange issues with the ContactCallDetail table. It does not seem to update in real time, seems to update in batches, and 2 hours later. So you will get an update to the table say every 15/30 seconds, with a bunch of calls from about 2 hours ago.
Has anyone else had these issues or know how to fix it?
I can't say I'd ever paid attention to the date fields in rtcsqssummary as they're not massively significant and I tend to look at the DB for historical reporting mainly.
I have checked my system here and I see the same thing - rtcsqssummary shows the local server time stamp, but the records in the historical tables are in UTC.