Hello all,
We upgraded to Cisco UCCX version 8.x a few months ago. There is a requirement for creating a custom report. We are able to connect to Informix database but when trying to query the data, we notice that the data is abnormal. For example - data show lots of calls (more than 1000 calls) during 00:00 to 4:00 but actually there were only two agents working during that time.
We later found document from Cisco https://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_8_0/user/guide/uccx801dbschema.pdf that the date and time field in the database are stored in Coordinated Universal Time (UTC) which is behind our local time (GMT +7).
Is there any way to change the date and time field in the database to have it stored in another time format (GMT +7)? Or any suggestion on how to retrieve the raw data from database with correct time?
Thanks,
Sovannary