SQL Query for Vulnerabilities with specific sites and severity

InsightVM SQL Queries
,
1

Hi Folks,

I’m a fresher in SQL queries.

I need some help to build a SQL query to report when a new vulnerability found in the InsightVM database for some specific sites (NetworkPublicFacingOutside, AppsPublicFacingOutside, ServerPublicFacingOutside) with severity of Critical, High, and Medium. I need this report for our custom InsightConnect workflow. I appreciate if someone has already this query to provide me or build this query for me.

Thank you in advance for any collaboration and support.

Warm regards
HB Salimy

2

Are you doing this in the NeXpose report SQL, the DataWarehouse, or the “Platform Query Builder” ?

3

Hi Brad,

Thank you for your response, I would like to place this query in the InsightConnect workflows

Warm regards
Salimy