Oracle Analytics Cloud and Server

Products Banner

List of reports in BIP instance

Received Response
61
Views
3
Comments

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

Tagged:

Answers