Report on Report Objects That Are Not Currently In Use
book
Article ID: 112555
calendar_today
Updated On:
Products
CA Service CatalogCA Service Management - Asset Portfolio ManagementCA Service Management - Service Desk Manager
Issue/Introduction
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.
Environment
Release: Component: EEMCAT
Resolution
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.