This report must include the app name, project name, start date/time, end date/time, user name, first name, last name and type of user. Which query should I use to generate it?Thanks.
I don't have the actual query at this stage. However, recent thread is similar to your request.
Get Deployment report
I hope it helps you.
It is not possible to query the Oracle database to obtain the information required by audit?I don't know the full database schema but I suppose the information must be there.
Database schema is not public at this stage. So, we cannot provide specified queries.
Existed reports or dashboard may not be enough for your expectation. If so, please raise an idea.
If you want to know back ground queries during operations, you can turn on JMX trace.
Creating report or refreshing dashboard, and then queries are recorded in nolio_dm_all.log on NAC.