UCCX SQL Query to get list of applications and their associated scripts

[Gilbert.Allard]

Looking for help in building an SQL query to return a list of UCCX applications and their associated scripts.

So far, all my attempts have resulted in the following error:

Internal CLI Error:  java.sql.SQLException: com.informix.asf.IfxASFException

Thanks.

[Graham Old]

This will get you the list of applications

run uccx sql db_cra select applicationName from crsapplication where active = 't'

This will get the list of triggers

run uccx sql db_cra select APPLICATIONNAME,TRIGGERNAME,misc1 from crstrigger where active = 't'

This will get the list of scripts

run uccx sql db_cra_repository select filename from scriptsfiletbl

Note that scripts live in the db_cra_repository and not db_cra

What I don't know is how to map the application to the script name.

Can you use the api as that will give you the application name and the script name

Graham

[Gilbert.Allard]

Thanks Graham.

The mapping between each application and its script(s) is really what I'm looking for.  From other posts on the web, it looks that it might resides in the CrsApplication table, in a field called privateData.  However, this field contains data that Cisco doesn't expose to customers.

Any other idea would be appreciated.

[Graham Old]

The privatedata is a binary field, if you extract it and convert it to ASCII then it looks like this

In there you can see SCRIPT[PromptRecord4.aef] which is correct

If you can get that out then your SQL skills are much better than mine

Graham