How can we identify the output folders for all Advanced Reporting Schedules?
Release : 16.0.3, 16.1.0
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.