Vulnerability Item form to report CI relationship with the Business Application

janvitha
Giga Contributor

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!

1 REPLY 1

Manuel Stimac
Mega Sage

Hi @janvitha,

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

Create a new CMDB Query:

ManuelStimac_1-1669825071064.png

 

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

ManuelStimac_0-1669824980854.png

Set the Properties of the connection:

ManuelStimac_2-1669825181145.png

 

Specify some filters for better performance: (Optional)

ManuelStimac_3-1669825261170.png

 

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)

ManuelStimac_4-1669825310996.png

 

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

ManuelStimac_5-1669825380652.png

Hope this helps!

 

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

 

 

 

 


If my answer helped you, please mark it as Helpful/Solution.
Thanks & many Regards - Manuel