Report on Report Objects That Are Not Currently In Use
Article ID: 112555
Updated On:
Products
CA Service Catalog
CA Service Management - Asset Portfolio Management
CA 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
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.
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.
Feedback
Yes
No
Powered by
