cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1150
Views
0
Helpful
1
Replies

UCCX 8.x - Database

sovannary.huy
Beginner
Beginner

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
1 Reply 1

Edward Umansky
Enthusiast
Enthusiast
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers