Looking for ways by which admins can export all non-default reporting content and report totals for a specific jaspersoft organization.
Release : Clarity PPM 15.8
Component : CA Business Intelligence JasperReports Server 7.1
The KB has two attached SQLs that need to be run against the jaspersoft schema and resulting output is described below.
Query output lists all custom (non-default) reporting content available on the Jaspersoft organization
2. Jaspersoft Totals
Query output summarizes reporting content as totals based on item types such as Domain, Adhoc queries, and studio reports.
Note: Replace tenant name in the respective SQLs. It is currently "Tenantname = 'XXXX'"