Find out list of adhoc view and adhoc reports located on a JasperReports Server

We can get the list of adhoc views and adhoc reports from the jasperserver database using Auditing and Monitoring Events.

-- For this, we need to set the following properties as 'true' in the js.config.properties file. By default, this property is set to false.

    i. feature.audit_monitoring.enabled 
    ii. audit.records.enabled 
    iii. monitoring.records.enabled

Before we make the changes, please stop the server, make the changes, save it, and restart the server.

-- After these changes, run the below query against the jasperserver database to get the list of ad hoc views and reports from JRS:
    select * from jiauditevent where RESOURCE_TYPE IN ('AdhocDataView','ReportUnit') and EVENT_TYPE='saveResource';
    
-- We have also run the same query against the local database. Please refer to the attached screenshot for more details.  

Ref Case: #02213433