Sql query based on tags, vulnerabiiity criticality and exploits

InsightVM SQL Queries
1

in query builder, i use this: asset.tags.type CONTAINS ‘criticality’ && (asset.tags CONTAINS ‘very high’ || asset.tags CONTAINS ‘high’) && vulnerability.exploits.size > 0 && (vulnerability.severity CONTAINS ‘critical’ || vulnerability.severity CONTAINS ‘severe’)

I’d like to build a query using sql and schedule reports based on the above query.

thanks

2

Hi @dphillips2 , I think this is a different schema, take a look to the datamodel to query in order to schedule a report.

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

Hope this helps