Need a SQL query to list all the scheduled OTBI Analsis and dashboards

Vishal Gala

Summary

We need to review and track all the OTBI reports that are scheduled via agents

Content

Having the ability to query this out helps us understand who all have scheduled the reports other wise there is no easy way for the administrator to know..

Tom Strudley

Hi Vishal

Have you checked the logs in OBIEE Administration>Manage Sessions or Administration>Manage Agent Sessions

It's not pretty but will show you analyses run and gives you some sort and filter options. Be careful though as you can clear the cache

Thanks
Tom

Akshay Aiyer

Hi Vishal!

May I know how have you attained the resolution for this query of yours?

Our business here also wants to keep track of all the BI Scheduled Reports with the timings and the recipients. With the list being long we also are trying to figure out a SQL query or a way to get it but unable to.

 

Thanks,

Akshay