How to get query for the CABI reports

book

Article ID: 206104

calendar_today

Updated On:

Products

CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) NIMSOFT PROBES DX Infrastructure Management

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.