SQL Query Examples
Rapid7-provided examples (Recommended)
Find examples of 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 InsightVM use the same SQL queries
You can use InsightVM SQL queries the same way as Nexpose SQL queries.
You can also find examples of SQL queries on the InsightVM SQL Queries Rapid7 Discuss page: https://discuss.rapid7.com/c/insightvm/queries/
SQL query examples for InsightVM in Rapid7 Discuss are provided by community members and therefore may not have been tested by Rapid7.