Query Report Instances on Jaspersoft Server
search cancel

Query Report Instances on Jaspersoft Server


Article ID: 227505


Updated On:


Clarity PPM On Premise


Is there a way to query the Jaspersoft schema in order to clean up or remove/delete excessive report instances on the server?


Jaspersoft 7.1


Per Tibco, review the TIBCO JASPERREPORTS® SERVER REST API REFERENCE RELEASE 7.1 document CHAPTER 6 "THE resources SERVICE" for reference of the following detail steps:

1) Issue the following JRS REST GET request to search the repository database to get all report unit details.

GET http://<host>:<port>/jasperserver[-pro]/rest_v2/resources?type=reportUnit

(refer to: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v710/resources-service#Searching_the_Repository)

2) Process the response body of the above request. For each resourceLookup items, review its "creationDate" to determine the eligibility for the report unit removal;

3) For those report units that need to be deleted, issue the following JRS REST DELETE request to remove it from the repository database:

DELETE http://<host>:<port>/jasperserver[-pro]/rest_v2/resources/path/to/resource

where the /path/to/resource information is from the "uri" field in the response body of the search in step 1.

(refer to https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v710/resources-service#Deleting_Resources)