Categories
Is there a SQL query that will show when last a BI Report has been run by a user?
Answers
-
Hi @User_27DEY
Yes.
if you think we have answered your quesiton, please feel to mark this thread as Answered.
Regards,Arjun
0 -
What is the SQL can be used to check the reports audit if " sage Tracking" is enabled? it seems we will have to do that. thanks
0 -
Hi @User_27DEY
If the usage tracking is enabled you can able to see the data in our below RCU DB tables -
S_NQ_ACCT, S_NQ_DB_ACCT, S_NQ_INITBLOCK.
Also check from UI
- Sign in to your service.—>
- Click Console. —>
- Click System Settings. —>
- Click Usage Tracking. —>
- Enable usage tracking for your system. Ensure Enable Usage —> Tracking is switched on.
- https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/track-usage.html#GUID-4B1F414A-A071-42A2-972C-BD4ED5D47CD5
- Regards,
- Arjun
0 -
we are asking for a sql not go through the application to find, is there any SQL to do that? thanks
0 -
No. With out enabling the tracking you can't get the details using sql query. After enabling only you can able to utilize the sql query to return the details.
Regards,
Arjun
0 -
what is the SQL that can query from the DB? thanks
0 -
what is the SQL that can query from the DB? thanks
You have been given the default table names that Usage Tracking does use in OBIEE by Arjun above.
The instructions to check if Usage Tracking is enable, or to enable it, do not apply to OBIEE 12c because they are for OAS/OAC.
For OBIEE 12c you can easily find how to enable in the documentation by searching "Usage Tracking", like
Also in the documentation you can find the description of the columns of the usage tracking tables:
You have all you need to write the SQL query, do you agree?
It's quite difficult to give the exact piece of SQL you need, mostly because nobody in here know what your auditors are asking you, but you have been given all the pieces, with direct links to the doc to quickly find all the details, it should be about 5-15min to write the query.
1 -
Thanks, do you know if it requires license to enable the "Usage Tracking" ? or it is free feature? thanks
0 -
Hi @User_27DEY
Its an part of feature only no separate license is required.By default its disabled, you need to enable the same to utilize the feature.
Regards,
Arjun
0 -
thanks
0
