I needed a report export that had schedule's emails in it, so I took this and changed it for my own needs. I didn't do the best job in matching up all the new IDs but did it quickly. Posting it in case anyone else might need it for this.
SELECT * FROM jireportjob j LEFT OUTER JOIN jireportjobcalendartrigger j1 ON j.job_trigger = j1.id LEFT OUTER JOIN jireportjobmail j2 ON j.mail_notification = j2.id LEFT OUTER JOIN jireportjobmailrecipient j3 ON j.mail_notification = j3.destination_id LEFT OUTER JOIN jireportjoboutputformat j4 ON j.content_destination = j4.report_job_id LEFT OUTER JOIN jireportjobparameter j5 ON j.content_destination = j5.job_id LEFT OUTER JOIN jireportjobrepodest j6 ON j.content_destination = j6.id LEFT OUTER JOIN jireportjobsimpletrigger j7 ON j.job_trigger = j7.id LEFT OUTER JOIN jireportjobtrigger j8 ON j.job_trigger = j8.id; LEFT OUTER JOIN jiuser j9 ON j.owner = j9.id;
How-to find all scheduled reports in jasperserver repository with the sql query
in How-To
Posted
I needed a report export that had schedule's emails in it, so I took this and changed it for my own needs. I didn't do the best job in matching up all the new IDs but did it quickly. Posting it in case anyone else might need it for this.
SELECT * FROM jireportjob j
LEFT OUTER JOIN jireportjobcalendartrigger j1 ON j.job_trigger = j1.id
LEFT OUTER JOIN jireportjobmail j2 ON j.mail_notification = j2.id
LEFT OUTER JOIN jireportjobmailrecipient j3 ON j.mail_notification = j3.destination_id
LEFT OUTER JOIN jireportjoboutputformat j4 ON j.content_destination = j4.report_job_id
LEFT OUTER JOIN jireportjobparameter j5 ON j.content_destination = j5.job_id
LEFT OUTER JOIN jireportjobrepodest j6 ON j.content_destination = j6.id
LEFT OUTER JOIN jireportjobsimpletrigger j7 ON j.job_trigger = j7.id
LEFT OUTER JOIN jireportjobtrigger j8 ON j.job_trigger = j8.id;
LEFT OUTER JOIN jiuser j9 ON j.owner = j9.id;