How to get SQL query from Jasper Reports

  • Document ID:7014477
  • Creation Date:30-Jan-2014
  • Modified Date:30-Jan-2014
    • Micro Focus Products:
      ZENworks Configuration Management

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:
  1. Login to ZRS
  2. Click on manage->server settings->Ad-hoc settings->
  3. Select Enable view query in Ad-hoc editor
  4. 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.
  1. Login to ZRS
  2. Click on manage->server settings->Log setting
  3. Change SQL query executer to Debug instead of Error
  4. Run SQL based report
  5. Open jasperserver.log from C:\Program Files\novell\zenworks-reporting\js\apache-tomcat\webapps\jasperserver-pro\WEB-INF\logs and get the query