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.
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.