List reporting for Vulnerable items , Configuration item and impacted Services.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2023 01:53 AM
Dear team,
Our customer is searching for a report that is showing all vulnerable items plus configuration items plus all related services with it to be displayed in one place, so that every user can see their own affected services, configuration item and vulnerabilities as well. Please keep in mind that the amount of data for CIs and VITs is big one, since they already had 3 scanners integrations. I was trying to achieve the reporting capability using PA, but without success. The relationship between CI and VITs is stored here sn_vul_m2m_ci_services, but seems like the issue comes with displaying the 1 CI related with 1 VIT, related with many services. Could you please advice on any sufficient way of developing that requirement?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-24-2023 03:30 AM
@mariya_sabeva If you build reports on relationship tables then you will get multiple entries for 1 to many relations. You can also think of creating database views to combine result.