Categories
- All Categories
- 148 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
List of reports in BIP instance

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
Answers
-
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
0 -
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,
0 -
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.
0