Hi,
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.
Regards
Yas