I need a way to list/report all report objects that aren't in use currently. We are at a point where we need to clean up our report objects. If we can list which forms are using a report object, that would be great as well.
For a simple list of the report plugins which are in use it looks like you can simply run something like:
select * from USM_FORM_COMPONENT_ATTRIBUTES where ATTR_NAME like 'reportobjid'
This should only return the components which have a value for this and the attr_value field will like the report plugin name or ID.
If you want more details such as what is using them then you would need to tie that to a number of other form and offering tables which gets much more complex.
The report objects are defined in USM_REPORT_DATAVIEW and other report tables.