Solved!!!
SSH to the CUIC box and run the following commands:
run sql select id, name from cuic_data:cuicreportdefinition
run sql select name, reportdefinitionid from cuic_data:cuicreport
Join the 2 bits of data together using the id and reportdefinitionid and hey presto you have a list of report definitions and dependent reports.
Or if you want it joined for you you can use the following command instead:
run sql select rd.name, rp.name, rp.reportdefinitionid
from cuic_data:cuicreportdefinition as rd
inner join cuic_data:cuicreport as rp on rd.id = rp.reportdefinitionid
Karen
