New to SQL query

[vm1 (vm)]

Hi,

If I want to start using SQL Query in Rapid7 Insight VM, where can I start from. Can you share some resources to begin.

Thanks in advance

[john_hartman]

https://docs.rapid7.com/insightvm/understanding-the-reporting-data-model-dimensions/

Understanding the reporting data model: Facts | InsightVM Documentation

[john_hartman]

Dimension versus Fact Tables

The fact tables are usually aggregated and only list out IDs to map to the dimension tables. So an example fact table would show what vuln ids are on what asset id. If you wanted more info on the asset like it’s IP or Host name then that info would come from the dimension table dim_asset. If you wanted the name of the vulnerability that was found on that asset it would also come from a dimension table dim_vulnerability. So for your example, if you just wanted a count of how many critical vuln…

[do2222]

Here are a bunch of templates to start with. Do you know where to place them?

GitHub - rapid7/insightvm-sql-queries: InsightVM helpful SQL queries