Total # of Vulnerability Metrics

Does anyone know of a custom SQL query for a report of the following:

Total # of vulnerabilities at the start of April 1 (Beginning of Q2)
Total # of vulnerabilities at the end of May 30 (End of Q2)

The native reporting that R7 provides seems to revolve around vulnerabilities found, vulnerabilities remediated, etc. but never the total number at a certain point in time.

1 Like

You could use the fact_asset_date table to get this