what is the SQL that can query from the DB? thanks

we are asking for a sql not go through the application to find, is there any SQL to do that? thanks

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

Thanks, so it required to enable Usage Tracking?

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

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

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

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!

Thanks Yes, we login as the built-in admin. but only did once, and it does not work, so we gave up and asked the users to enable themselves which seems a nightmare. thanks again, if it still does not work, i will paste the errors, thanks again!

Thanks! the catalog is fine, but there are lot of agents might be that is why it does not work. what the tables are needed to copy? do we have any constrain? thanks again!

Thanks! we tried that option, but it still requires individual users to enable on their own since the agent is under "My Folder" which the user herself/himself has access to.

Thanks a lot!! Yes, we just migrated OBIEE 12.2.4 suite from ACS to OAS, both in OCI, during the migration, all the schedule jobs (belong to individual users, not just Publisher job) were disabled, do u know if there is any way we can enable them back instead of asking each user to enable them from the application (enable…

Thanks, localedefinitions.xml does not seem the correct file since we make changes to this file and it does not work, also we made changes from the front end, but this file did not get updated. so the changes made are not written to this file. thanks

Thanks, "copy the xml file from report advanced tab " where is this tab? we need the date format changed globally wherever there is "date" there, not just the reports. also, we do not have access to prod for the GUI changes, so have to find the xml file to migrate to PROD. thanks

thanks Gianni Ceresa, it is OBIEE12.2.1.4, basically we try to change the date format to DD-MMM-YYYY globally from the backend (not front end). can you please let me know how to do it to make it work? thanks,

Thanks Martin van Donselaar, do you know what files the changes made it written to from the backend? Thanks

Thanks bskumar.obiee, i added the tag in localedefinitions,xml config, but somheo it does not work for me, do you need to change anything else? thanks

Thanks Gianni, All the reports owned by the single/same owner and we do not care any dynamic ones if there is any. which table is the primary one/key that has the report names as the primary key? thanks again!!

Thanks Gianni, Can you please let me know what is the name of the table "agents logs tables in the database" ? Thanks

Thanks Gianni and Federico, we only need to know the active agent/scheduled reports receivers, we donot care any of the ones that have been disable/inactive. All we want is simple: Need all receivers for each active /enable scheduled report (Agent) . Thanks again, very appreciate it