How to get query for the CABI reports
search cancel

How to get query for the CABI reports


Article ID: 206104


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM)


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.