Vulnerability Item form to report CI relationship with the Business Application

[janvitha]

Hello!

We have a client requirement where we were asked to create a report for Vulnerability Items(VRM-Vulnerability response management).
The conditions are as follows:
1. As a form user,  I need a report showing the identified vulnerable item (CI) and its relationship to a Business application.
2. As a user, the report is displayed in a dashboard and can be filtered using the Business application and all vulnerable CI is listed.

We have a dataset which contains the business application &vulnerable item (CI) created ,which consists of more than 17 lakh record and its taking too much of a time to load in a list view in report format & the transaction is getting cancelled.

Can someone suggest how can we show the relationship in a report format .
can we really show the relation actually in a report list view format. If yes, please suggest.

Thanks in Advance!

[Manuel Stimac]

Hi @janvitha,

I would try to get the related CI's with the CMDB Query Builder:

Create a new CMDB Query:

Drag your Server class & the Service class into the query and connect the two with each other by clicking the small squares:

Set the Properties of the connection:

Specify some filters for better performance: (Optional)

RUN the query. This will open a Pop-Up with a new u_cmdb_qb_result table:
(Full table name can be found in the URL)

You can use this new table in reports if you like:

Hope this helps!

If this answer helps you please mark it as Helpful/Solution.
Thanks & Regards - Manuel