Average Risk Card

InsightVM
1

I have a site tech wanting the average risk score for his site as a good metric to see how he is doing. We have the monthly scorecard that gives that data but it would be easier to have that in the dashboard. Does anyone know of a way to get the average risk score for a site other than risk scorecard?

2

There is no way to do this through a dashboard however you could do a custom SQL report to essentially take the riskscore of each asset and spit out the average or just spit out each line for each asset and then open the csv in excel which usually calculates the average for that column when you select it.

SELECT fa.asset_id, fa.riskscore
FROM fact_asset fa
JOIN dim_site_asset dsa USING(asset_id)
WHERE dsa.site_id = {your site id}

OR to just display the average

SELECT avg(fa.riskscore)
FROM fact_asset fa
JOIN dim_site_asset dsa USING(asset_id)
WHERE dsa.site_id = {your site id}

to get the site id, simply navigate to that site within InsightVM and the site id will be in the URL at the end

1 Like