cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays
1058
Views
0
Helpful
1
Replies
sovannary.huy
Beginner

UCCX 8.x - Database

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

1 ACCEPTED SOLUTION

Accepted Solutions
Edward Umansky
Enthusiast

1 REPLY 1
Edward Umansky
Enthusiast

Content for Community-Ad

Spotlight Awards 2021