07-22-2021 10:31 AM
I have a customer running CCX 11.5.1.11001.34 and we are migrating to a new cluster running CCX 12.5.1.11001.348 in a new data center. I did a python script that I was able to use to migrate the vast majority of the data, but how to handle the scheduled reports is eluding me. I would do it manually, but there quite a few of them. I may be using poor search terms, but I haven't found anything yet. I see where I can export a custom report definition which worked fine, but nothing that helps me export scheduled runs of stock reports? Any suggestions would certainly be appreciated.
07-22-2021 05:46 PM
Does the section on scheduled jobs give you what you need?
https://community.cisco.com/t5/contact-center/user-list-for-cuic/td-p/3318509
07-23-2021 05:15 AM
Thanks, I'll give that a try!
07-23-2021 05:22 AM
Good luck, please let us know how it goes.
And can you expand a little on your comment re the script you used to export the other items, as far as what you meant? Aren't you going to need to import the new report definitions and not use the old as an example?
07-23-2021 05:27 AM - edited 07-23-2021 06:39 AM
The script I mentioned was to get data from the UCCX admin api to pull objects from the configuration repository on the old cluster and push them to the new cluster. The biggest challenge in that was where objects needed a refURL that included an id number. For example, "Customer Service" skill was id number 47 on the old cluster, but id number 83 on the new cluster. That was an issue for CSQ mappings in teams, skill and resource group assignments on resources (users).
07-23-2021 05:38 AM
I am not sure how to get to the cuic database. This is UCCX 11.5 with a co-resident CUIC. Here is what I tried.
admin:run uccx sql cuic select * from cuicscheduledreports Database name is invalid. Name = cuic Command failed.
I was using "?" on all the cuic commands, but no joy.
07-23-2021 07:51 AM
I'm not familiar with UCCX, but I know the UCCE/CUIC syntax is different.
I also found this, does this help you as far as the syntax, they specifically mention it for UCCX CUIC?
https://puck.nether.net/pipermail/cisco-voip/2015-October/040963.html
07-23-2021 08:56 AM
That helps a lot, thanks! I am trying to find a data dictionary for CUIC using terms like "cisco cuic 11.5 database schema", but coming up empty. I find lots of ICM and CCX stuff, but the database dictionaries are all for the configuration information. I will keep plugging along, but that definitely helps.
07-23-2021 09:09 AM - edited 07-23-2021 09:11 AM
I am making a like more progress. I was looking for a table list, but I recalled some way way back informix experience, and this gives me a start on a list of tables.
run sql select * from cuic_data:systables where tabname like '%cuic%'
Edit: This gave me even more detail of what I need.
run sql select tabname from cuic_data:systables where tabname like '%cuic%' and nrows > 0
07-23-2021 12:59 PM
If you look in that first post I sent, I think that's what you're looking for as well? select * from "informix".systables
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide