SQL example - proof of a specific remediation
This example query allows you to report on a specific remediation. Checking progress on a remediation report previously shared with the asset owners is a common use case for this.
This example is for "remove world write permissions".
sql
1SELECT dsi.name AS site, da.ip_address, da.host_name, dos.description AS operating_system, favi.date AS scan_finished, proofAsText(ds.fix) AS remediation, proofAsText(favi.proof)23FROM fact_asset_vulnerability_instance favi45JOIN dim_vulnerability_solution dvs USING (vulnerability_id)67JOIN dim_asset da USING (asset_id)89JOIN dim_operating_system dos USING (operating_system_id)1011JOIN dim_solution ds USING (solution_id)1213JOIN dim_site_asset dsa USING (asset_id)1415JOIN dim_site dsi USING (site_id)1617WHERE solution_id IN (1819SELECT solution_id2021FROM dim_solution_highest_supercedence2223WHERE superceding_solution_id IN (2425SELECT solution_id2627FROM dim_solution2829WHERE lower(summary) LIKE '%remove world write permissions%'3031)3233)
Did this page help you?