How to create a list of all vulnerabilities for each asset in an asset group that can be exported

InsightVM Query Builder
1

Trying to figure out how to generate a single list that contains for each asset in an asset group, all vulnerabilities.

I can get a list of all assets in a group but only a count of the vulnerabilities for each.
I can get a list of all vulnerabilities in an asset group but only with a count of the number of assets.

I want to export to Excel, something like this:

Asset Name Vulnerability CVE Vuln Description Vulnerability Risk Score

Asset01 Vuln CVE #1 Vuln #1 Desc Vuln #1 Risk Score
Asset01 Vuln CVE #2 Vuln #2 Desc Vuln #2 Risk Score
Asset01 Vuln CVE #3 Vuln #3 Desc Vuln #3 Risk Score
Asset02 Vuln CVE #1 Vuln #1 Desc Vuln #1 Risk Score
Asset02 Vuln CVE #3 Vuln #3 Desc Vuln #3 Risk Score
Asset03 Vuln CVE #2 Vuln #2 Desc Vuln #2 Risk Score

Appreciate any help.
Thanks - Mark

2

A report might work for you instead.
Go to Reports –> Console Generated –> Manage report templates –> New
Under ‘Template Type’ select ‘Export (CSV Format)
Select the fields you want in the report. Then run this report against the asset group.

3

mwhite - thank you for the reply, much appreciated. I’ll look into this further. Thanks again!