SQL Query Examples

Rapid7-provided examples (Recommended)

Find examples of Vulnerability Management (InsightVM) SQL queries on the Rapid7/insightvm-sql-queries GitHub repository: https://github.com/rapid7/insightvm-sql-queries

This repository is intended to serve as a place to store and share SQL queries for use in InsightVM. These queries are sorted into two separate folders based on their use with the reporting data model, versus the data warehouse.

ℹ️

Nexpose and Vulnerability Management (InsightVM) use the same SQL queries

You can use Vulnerability Management (InsightVM) SQL queries the same way as Nexpose SQL queries.

Community-based examples

You can also find examples of SQL queries on the Vulnerability Management (InsightVM) SQL Queries Rapid7 Discuss page: https://discuss.rapid7.com/c/insightvm/queries/

⚠️

Query validation

SQL query examples for Vulnerability Management (InsightVM) in Rapid7 Discuss are provided by community members and therefore may not have been tested by Rapid7.