Report from Jaspersoft showing default custom content and totals

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Looking for ways by which admins can export all non-default reporting content and report totals for a specific jaspersoft organization.

Environment

Release : Clarity PPM 15.8

Component : CA Business Intelligence JasperReports Server 7.1

Resolution

The KB has two attached SQLs that need to be run against the jaspersoft schema and resulting output is described below.

1. JasperReportList

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'"