Need SQL Queries running in back-end for OOTB SOI reports in Jaspersoft
book
Article ID: 137126
calendar_today
Updated On:
Products
CA Service Operations Insight (SOI)
Issue/Introduction
We basically need the SQL queries running in back-end of all the OOTB SOI reports and also the Drill Down Reports SQL Queries present in SOI folder in Jasper Reports Server.
Environment
Release : 4.2
Component : Service Operations Insight (SOI) Manager
Resolution
You can find all the SQL queries in the soi_reports_content6.3.zip whihc is shipped as part of the reports installer. Extract the contents and go to folder resources\public\ca\soi\reports. In notepadd++ search for the string "queryString language="SQL"" in file names ending with "_jrxml.data". You will see all the queries used in the reports.