Environment
Novell ZENworks Configuration Management 11.2
Novell ZENworks Configuration Management 11.3
Situation
How to get the SQL used by Jasper ZRS reports.
Resolution
How to get SQL query for ad-hoc view:
- Login to ZRS
- Click on manage->server settings->Ad-hoc settings->
- Select Enable view query in Ad-hoc editor
- Create ad-hoc view, one button will be enabled to see query. Click that and get query
How to get SQL query for SQL based report.
- Login to ZRS
- Click on manage->server settings->Log setting
- Change SQL query executer to Debug instead of Error
- Run SQL based report
- Open jasperserver.log from C:\Program Files\novell\zenworks-reporting\js\apache-tomcat\webapps\jasperserver-pro\WEB-INF\logs and get the query