SQL example - new and remediated vulnerabilities

Hello Team,

I wanted to check with you all if the “SQL example - new and remediated vulnerabilities” query on the below article works for you or not.

(SQL example - new and remediated vulnerabilities | InsightVM Documentation)

I tried running this query multiple times, but it always gives me the NEW vulnerabilities list and never showed up any remediated ones.

Thanks,
Parth

Hi Parth,

Are you running the report against a site or asset group?

Hi @Zach,

I tried running the report against a site and an asset group. I don’t see any results when running a query against an asset group and a site. But when I run the query against a specific scan, it resulted in NEW vulnerabilities.

Basically, we have a requirement wherein every month we need to submit a report showing the list of open and remediate vulnerabilities for tracking purposes.

I hope this helps.

Thanks,
Parth