Is there a SQL query that will show when last a BI Report has been run by a user?

User_27DEY

Hello, does any one know if there is a SQL query that will show when last a BI Report has been run by a user? all the data directly pull from the source database not the OBIEE DB using connection pool defined in the RPD. but due to audit purpose, the reports access need to be audit, this is OBIEE 12.2.4 on premises. thanks! appreciated your help!

Wayne Van Sluys

For BI Publisher you need to enable monitoring and auditing then you can query the tables as the post indicates.

Wayne Van Sluys

Usage tracking is tied to Answers and Dashboards. It will tell what was run and by what user.

BI Publisher has its own tracking which is what was discussed in the link you provided.

Mallikarjuna Kuppauru-Oracle

Hi @User_27DEY

Can you refer below - with out usage tracking you can't get the tracking history.

Track usage.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/track-usage.html#GUID-2C21BB2B-E7C8-4F2C-97D6-12F5A361A56F

Regards,

Arjun

Wayne Van Sluys

Do you have Usage Tracking Enabled?

User_27DEY

Thanks a lot Wayne! No, its not enabled, that is the problem we have, but the reports are being audited now. Any SQL can do that? Thanks again!

Wayne Van Sluys

Unfortunately no way that I know of. I do not think Session information is going to log files in weblogic or fusion middleware.

User_27DEY

Thanks, but for Hyperion, they have a way to do that, please see the post below, thanks

https://community.oracle.com/customerconnect/discussion/589631/is-there-a-sql-query-that-will-show-when-last-a-bi-report-has-been-run-by-a-user

User_27DEY

Also "Usage Tracking Enabled" is audited the users not the reports correct? thanks!

User_27DEY

Thanks, this is not BI Publisher. its Answers and Dashboards. Thanks.

User_27DEY

Thanks, so it required to enable Usage Tracking?