search cancel

Report on Report Objects That Are Not Currently In Use


Article ID: 112555


Updated On:


CA Service Catalog CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager


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.


Component: EEMCAT


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.