Report on Report Objects That Are Not Currently In Use

Document ID : KB000112555
Last Modified Date : 30/08/2018
Show Technical Document Details
Question:
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.
Answer:
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.