Report from Jaspersoft showing default custom content and totals

book

Article ID: 193526

calendar_today

Updated On:

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

Attachments

1592831798278__JasperReportTotals.sql get_app
1592829823827__JasperReportList.sql get_app