list views / tables used in all reports

[renssak]

Hi all,

is it possible to list all views / tables which are used in all jasper-reports?

We currently have no documentation, which report uses which table or view and I want to set up a report for this.

Regards

Martin

[hozawa]

There are 2 ways. First is to use REST v2 API to get all report recursively. You'll need to write a program to do this.

The second way to to directly look at the jasperserver database table jiresource and find jrxml files.

[renssak]

Thanks hozawa,

but in jiresource I can see the reportname.

What I am looking for is the database view or tablename I am using in the report query.

If I can find the whole query in thejasperserver database this would help me, too.

Martin