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.
