Need sql queries to run manually for the CABI reports.
Release : 20.3
Component : UIM - CABI
For out of the box report provided by CABI.
please follow the below steps in order to collect the queries:
Login to CABI machine.
On the file system, navigate to ../Nimsoft/probes/service/wasp and open wasp.cfg
On the setup section at the end, remove "-Dorg.apache.commons.logging.LogFactory=org.apache.commons.logging.impl.LogFactoryImpl" and save the file.
Restart CABI robot.
Once the CABI is up and running, Login to CABI server as superuser and go to Manage --> Server Settings.
On the log collectors window, look for "SQL Query Executer" and set it to debug.
Now, run any report of your choice and look for the corresponding query in "../Nimsoft/probes/service/wasp/webapps/cabijs/WEB-INF/logs/jasperserver.log" file.