We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Updating the admin console's "Back to" product link
How to use the update-config script
How to check your JVM configuration name
How to use the validate-config-values script
Understanding Visibility API Logging
Updating Information Source, Source System
How to increase the heap size of server-util script executions
Insight System Options, Export
How to enable multi-threading on Insight's data loads
Configuring the ER rich client to connect to multiple ER instances

SQL query to list Perceive Reports and Ad-hoc Views

Gerard Cafaro

March 16, 2020 17:51

The SQL query below will list the following information about Perceive reports and ad-hoc views. The query can be run from the SQL console or directly against the Perceive database.

Name
Description
Date created
Date updated

SELECT * 
FROM JIResource
WHERE resourceType IN ('com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.ReportUnit','com.jaspersoft.ji.adhoc.AdhocDataView')

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

Related articles