InsightVM - Query to obtain records of a certain vulnerabilitity that has appeared on an asset and provide a history of when it was discovered and then remediated

InsightVM SQL Queries
1

Good morning,

We are trying to provide information for one of our environments and specifically one that has had a vulnerability appear almost monthly.

It gets remediated and then reappears, and we need to be able to convince the admins that they need to look further into what is causing the vulnerability to appear and we want to try and provide hard proof that this vulnerability has appeared multiple times even when it is addressed.

Any good queries that can be used?

2

Outside of the PROOF no not really, depending on the Vulnerability, the OS and the Level of Credential you have you can script something to pull whatever else you may need as substantial proof values