Feature Request: Please add CWE to Power Query

InsightVM Query Builder
1

Hi Folks,

We’d like to build reporting around CWE’s but the information and reporting in Rapid7 InsightVM isn’t there yet.

Any chance of getting a CWE search field added to Power Query?

Thanks!

2

Anyone out there pulling CWE reports through an SQL query?

#Bueller

3

CWE numbers can be pulled via sql from either console or, if from data warehouse if you have one set up. this should get you started….

SELECT f.asset_id, v.title, r.reference AS cwe
FROM fact_asset_vulnerability_finding f
JOIN dim_vulnerability v ON v.vulnerability_id = f.vulnerability_id
JOIN dim_vulnerability_reference r ON r.vulnerability_id = v.vulnerability_id
WHERE r.source = 'CWE';