How to create customized reports using UIM CABI
Article ID: 10623
Updated On: 03-12-2025
Products
Issue/Introduction
This document demonstrates how you can create customized reports using UIM CABI.
You must have administrator privileges for users to create the reports using CABI. So please login to Unified Management portal (UMP) using administrator user.
Environment
Release: DX UIM: 20.4*/23.4*
Component: CABI
Resolution
- Login to UMP and click on “Unified Dashboards”-> “CA Business Intelligence Dashboards”. You will be redirected to soft link where you can click it for accessing CABI Home page.
Creating an Ad Hoc View:
-----------------------------
2. Click on “Create” option under “Ad Hoc Views” and select the data source “UIM Metrics Topic” and then click on OK.
You will be redirected to Ad Hoc view creation where you can see the list of Fields and Measures available for report creation.
3. Drag the required Fields / Measures to Columns or Groups and select the “Input Controls” for actual hosts and metrics to be selected for report creation.
4. Once you selected the Time Rage, group of devices (multiple hosts can be selected) and metrics then click on Apply and OK.
5. Save the report with proper name and location.
6. Once upon applying filters and saving the report the data will be shown as below.
Creating a report using Ad Hoc View:
-----------------------------------------
7. Click on “Home” icon (shows top left on the page) or “Create” -> ”Report” on top bar. You must have to select the Ad hoc view created in above and select the default report template and then click on OK.
8. Once you clicked on OK, report will be shown as below. However, you can save this report with different options like PDF, Excel etc.
9. Click on "Home" icon to go to CABI home page and then click on "View List" under Reports to view the reports created or you can search for report with report name.
Additional Information
To create report of servers in maintenance using result of sql query:
The query below works in SQL Query Editor. Created a JNDI datasource with CABI and successfully tested the connection. However, can't find an option to select the SQL Query as a datasource to create the report in CABI.
select distinct cs.name, cs.ip, cs.origin, ms.SCHEDULE_NAME, ms.DESCRIPTION, mw.START_TIME, mw.END_TIME from CM_COMPUTER_SYSTEM cs INNER JOIN MAINTENANCE_SCHEDULE_MEMBERS msm ON cs.cs_id=msm.CS_ID INNER JOIN MAINTENANCE_WINDOW mw ON msm.SCHEDULE_ID=mw.SCHEDULE_ID INNER JOIN MAINTENANCE_SCHEDULE ms ON msm.SCHEDULE_ID=ms.SCHEDULE_ID WHERE mw.END_TIME >=GETDATE()
Please refer to the following url:
CABI - Business Intelligence Dashboards
You can create your own dashboards and reports using the commercial edition of Jaspersoft Studio. This software is not provided with the CABI for UIM Dashboards. You can download a trial version of the software from the Download Jaspersoft Business Intelligence Suite page. To complete the installation, you must copy and then import the jasperserver.license file into Jaspersoft Studio. The jasperserver.license file is located in \probes\service\cabi\cabi.
You may also want to post a message to the community to see if anyone has already done this using Jaspersoft Studio before.
Feedback
