Is there a way to find the Last-Used-Date for a Report Facility object

Products

• Report Facility

Issue/Introduction

Is there a method to find the Last-Used-Date for a Report Facility (PRF) object.

Environment

 

Resolution

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 and Last Date (executed). The Time column is the Last Time (executed) column:

SELECT SUBSTR(PRF_ID,1,8) AS ID, 
PRF_TYPE, 
SUBSTR(PRF_NAME,1,8) AS NAME, 
PRF_UPDATE_DATE, 
PRF_LAST_DATE, 
PRF_LAST_TIME 
FROM PTI.PTPRF_LIB_vvvv
ORDER BY PRF_UPDATE_DATE DESC ;