SQL Query Examples

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.

Community-based examples

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

Query validation

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