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	1710	November 17, 2022
About the SQL Queries category	0	533	June 5, 2020
Query only returns values after 00:00 AM	0	11	June 8, 2023
SQL Help Needed FIRST FOUND DATE messing my Reports up InsightVM	4	33	June 8, 2023
Get scan based on scan name	1	19	June 8, 2023
New to SQL query	2	19	June 8, 2023
Patch Compliance	4	44	June 8, 2023
Dimension versus Fact Tables	2	65	June 2, 2023
Vulnerabilities SQL export different from what i see on asset in the console	0	42	June 2, 2023
Fact_all table doesn't include all	4	72	May 31, 2023
SQL query CVSSv3>=9 AND (CVSSv2>=9 if CVSSv3=NULL)	3	76	May 25, 2023
SQL query - List of vulnerabilities with and without exceptions	2	67	May 24, 2023
Categorize vulnerabilities by detection type?	4	126	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	47	May 18, 2023
Report\query to classify by most recent Windows Monthly Update installed	1	96	May 15, 2023
How to add vulnerability proof to SQL query InsightVM , sql	4	208	May 12, 2023
SQL Report Efficiency	1	88	May 11, 2023
Issues with query that used to work InsightVM , sql	4	119	May 11, 2023
Expiring SSL Cert Query for Specific CA	14	260	May 10, 2023
SQL Query to Return all Known Exploited Vulnerability for An Asset	1	86	May 5, 2023
SQL query for asset scan history	9	264	April 28, 2023
SQL to export data used in Risk And Assets Over Time graph on Home page	5	150	April 24, 2023
Tagging Multiple assets InsightVM , sql	2	151	April 18, 2023
Patch-Report.sql returning blank	0	78	April 17, 2023
Find the assets with Obsolete software	3	252	April 17, 2023
SQL Query export failed	1	101	April 5, 2023
Using IN and a sub-query that ORDERS BY, and grouping	2	145	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	2041	March 24, 2023
Is there a way to query fact _date tables?	7	160	March 24, 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…