get SQL-Queries of all Jasper-Reports

[renssak]

Hi all,
I'm looking for a way to get all the SQL quelies of all Jasper reports in the repository.
Is there a possibility? I haven't found anything yet ......
My problem is that I currently have around 100 database views that were originally created for Jasper reports. A large part is no longer required and should be deleted from the database. 

Unfortunatelly I have no overview of which views are still used in reports.
Thanks in advance.

I am currentyl using Jasper Reports Server Version 6.4.2 (Commercial Version) with Oracle for the Jasper-repository.

Regards
Martin

[jgust]

I don't know about server functionality but for the jrxml files, you can use a grep tool to find your specified content.  In your case that would be items in the <queryString> tag.

I used dnGrep for Windows with the settings below and was able to save the results to a text file for further review.

Note that the regex the program uses is Microsoft's version of regex.  There is a help file for the regex they use to assist you.

[renssak]

Hi - sorry for my late answer an thank you for your answer.

I hoped there would be a solution via SQL.

To step through the jrxml files by script currently is not possible, because we still use the old iReport to edit the reports.

Perhaps, when we have migrates to JSS, I can build a script which steps though all jrxml-files to get the used queries - or better to get the used view-names in the queries. But this would be difficult, if there is more than one view used.