SQL Queries

Topic	Replies	Views	Activity
InsightVM SQL Queries Home SQL queries are a handy option in InsightVM that enable you to access asset and vulnerability data and generate custom reports to fit your team’s needs. If you’re looking to write one of these queries but you’re not sure…	15	1660	November 17, 2022
About the SQL Queries category	0	528	June 5, 2020
Dimension versus Fact Tables	0	8	June 1, 2023
Fact_all table doesn't include all	4	37	May 31, 2023
SQL query CVSSv3>=9 AND (CVSSv2>=9 if CVSSv3=NULL)	3	64	May 25, 2023
SQL query - List of vulnerabilities with and without exceptions	2	57	May 24, 2023
Categorize vulnerabilities by detection type?	4	114	May 18, 2023
SQL Query to list out the assets with the vulnerabilities which has exploits, along with the asset type (Server or Workstation)	0	41	May 18, 2023
Report\query to classify by most recent Windows Monthly Update installed	1	92	May 15, 2023
How to add vulnerability proof to SQL query InsightVM , sql	4	190	May 12, 2023
SQL Report Efficiency	1	79	May 11, 2023
Issues with query that used to work InsightVM , sql	4	112	May 11, 2023
Expiring SSL Cert Query for Specific CA	14	252	May 10, 2023
SQL Query to Return all Known Exploited Vulnerability for An Asset	1	83	May 5, 2023
SQL query for asset scan history	9	251	April 28, 2023
SQL to export data used in Risk And Assets Over Time graph on Home page	5	144	April 24, 2023
Tagging Multiple assets InsightVM , sql	2	148	April 18, 2023
Patch-Report.sql returning blank	0	74	April 17, 2023
Find the assets with Obsolete software	3	244	April 17, 2023
SQL Query export failed	1	95	April 5, 2023
Using IN and a sub-query that ORDERS BY, and grouping	2	140	April 3, 2023
SQL Query Assistance - Need to join Fact_Asset_Vulnerability_Age	0	79	March 28, 2023
Finding Application, Configuration, and Patch Vulnerabilities	36	2025	March 24, 2023
Is there a way to query fact _date tables?	7	157	March 24, 2023
Search for specific CVE incuding location information InsightVM	7	229	March 22, 2023
Internal Schema vs Data Warehouse Schema graphics	3	135	March 16, 2023
SQL Query Trending Report	1	134	March 16, 2023
SQL Query specific CUSTOM Tags	2	138	March 16, 2023
SQL query to compare policy scan results	0	104	February 24, 2023
Wanted to Query the database to list all remediated vulnerabilities and time it took to remediate	3	187	February 23, 2023

InsightVM SQL Queries Home

SQL queries are a handy option in InsightVM that enable you to access asset and vulnerability data and generate custom reports to fit your team’s needs. If you’re looking to write one of these queries but you’re not sure…