Finding table field for Reporting Jobs - Output to Repository in Jasper DB schema

Products

• Clarity PPM On Premise

Issue/Introduction

How can we identify the output folders for all Advanced Reporting Schedules?

Environment

Release : 16.0.3, 16.1.0

Resolution

You may use a SQL query similar to the following:

SELECT *
 FROM JIREPORTJOB JOB
INNER JOIN JIREPORTJOBTRIGGER TRIG
ON JOB.JOB_TRIGGER = TRIG.ID
INNER JOIN JIREPORTJOBOUTPUTFORMAT OUTPUT
ON OUTPUT.REPORT_JOB_ID = JOB.ID
INNER JOIN JIUSER USR
ON USR.ID = JOB.OWNER
INNER JOIN JIREPORTJOBREPODEST DEST
ON DEST.ID = JOB.CONTENT_DESTINATION
INNER JOIN JIREPORTJOBMAIL EMAIL
ON EMAIL.ID = JOB.MAIL_NOTIFICATION

 

In the table JIREPORTJOBREPODEST there is a column called: "folder_uri"

This has the output folder for the reports.