How to get query for the CABI reports

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Need sql queries to run manually for the CABI reports.

Environment

Release : 20.3

Component : UIM - CABI

Resolution

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.