cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
120
Views
5
Helpful
1
Replies
Highlighted
Frequent Contributor

UCCX SQL Query

Hello Everyone,

Looking for a SQL query which lists the prompts (Wav files) with associated scripts in UCCX 11.6.

 

Regards,

 

MK

1 REPLY 1
Highlighted
VIP Mentor

Re: UCCX SQL Query

That's not possible. UCCX does not maintain a sql table with that information.

In my best estimation, you will need to either:
1) Programmatically scrape all of your scripts and pull out the prompt filenames
2) Periodically scrape all of your logs and pull out the prompt filenames which get played

Both of these have drawbacks and would not be 100%.

E.g.,
1) If you are supplying Prompt names in Application Parameters
2) If you have Prompts which only get played on rare circumstances; such as: holiday messages.

It would be cool to have a built in dependency record feature for more than just prompts. Like Documents and CSQs, to name two more. But, we don't have that. Best thing you could do now, if have good documentation which shows the links between all of the items.

I'd be interested to know if you find a solution though, as these are just my thoughts.