SQL Query Example: Most Vulnerable Site by Risk Score per Asset

Document created by synapsr on Feb 6, 2015
Version 1Show Document
  • View in full screen mode

Here's an example of a query to show most vulnerable Site by Risk Score per Asset.

You may also find our Risk Scorecard report useful for this type of data.

Improving Visibility into your Security Program – the Risk Scorecard Report

 

 

SELECT ds.name AS site, assets, riskscore,

(CASE riskscore WHEN 0 THEN NULL ELSE riskscore END) / (CASE assets WHEN 0 THEN NULL ELSE assets END) AS "RiskPerAsset"

FROM fact_site

JOIN dim_site ds USING (site_id)

ORDER BY "RiskPerAsset" DESC

 

 

The output shows:

Site

# of assets

Site Risk Score

Risk per Asset

1 person found this helpful

Attachments

    Outcomes