InsightVM Bulk Extract: Assets, Vulnerability Name, Solution for all Instances

[matt_domko_deprecated (Matt Domko)]

I’m a fan of the data warehouse feature

https://help.rapid7.com/nexpose/en-us/warehouse/warehouse-schema.html

There’s a SQL query (for use with the datawarehouse) in another post that gets you close to what you want:

Rapid7 InsightVM Historical Scans

One more question. Is there a possible sql query i can use to get a excel sheet of all the vulnerabilities for particular systems since node data only gives severity no cvss score is in there so when i save as pdf the person wont know if from that past history what cvss score the particular vulnerablities are? I just want to create a sort of database they can reference back. I see the database rapid7 has but it doesnt give you cvss on most of the ones i picked.

And finally, to work with tags… are you trying to find all vulns on a host with a tag that matches “foo”, or are you trying to aggregate by tag? (an example of the tags you’re looking for would be helpful)