Need SQL Queries running in back-end for OOTB SOI reports in Jaspersoft

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.