List of reports in BIP instance

Alejandro

Summary

How to get a list of reports ordered by last used date

Content

Hi, 

We've got several instances of BIP 10g, 11g -> Planning to migrate and consolidate all reports into one single version to be defined. 

I am trying to cleanup the catalogs and would like to see if its possible to get a list of reports, (name, datamodel, template, last usage) from the DB so I can build a meaningful list so we can make a decision about which reports are worth migrating and which ones are outdated and no longer in use. 

Ideally I would like this to work in the 10g environments. I've got access to the host machine as well as admin access to the BIP UI. 

Any ideas? 

Version

10g

Dir_Pal

check 

1: If this report is been used in application anywhere (Check that report table which would be useful)

2: if its used check the path in application of the reports

3: Check the check the catlog date.

else check this link 

https://technology.amis.nl/2016/01/31/usage-tracking-reports-using-oracle-enterprise-manager-13c-sam-tool/

Alejandro

Thank you - but I don't think the link applied as I am in an on premises instance + 10g. I was hoping there was some kind of SQL or if reports are stored in the file system a hint to where/what to look for. 

Regards, 

Skolli-Oracle

Please review the below doc:

How To Generate a Server Usage Audit Report for BI Publisher Enterprise (Doc ID 1326571.1)

For Scheduled reports, we can check from 'Report Job History"

I recommend to check the XMLP_SCHED_JOB table for XMLP_SCHED_OUTPUT tables for both online and scheduled reports.