Article ID: 107490
This document states whether or not there is a way to find the Last-Used-Date for a CA Report Facility object?
Is there a way to find the Last-Used-Date for a CA Report Facility object?
The query below should generate a report of all of the Report Facility objects that are being used by the current release. If a prior release was used, the Post Install PRFCNVRT job must successfully be executed to convert the objects from the older release into the current release. The Date columns listed on the report are the Last Updated, & Last Date (executed). The Time column is the Last Time (executed) column:
SELECT SUBSTR(PRF_ID,1,8) AS ID,
SUBSTR(PRF_NAME,1,8) AS NAME,
ORDER BY PRF_UPDATE_DATE DESC ;