Skip to content

Instantly share code, notes, and snippets.

@jfrantz1-r7
Created November 27, 2018 14:43
Show Gist options
  • Select an option

  • Save jfrantz1-r7/24da2e766792315b2f4ff2abe5b3ad14 to your computer and use it in GitHub Desktop.

Select an option

Save jfrantz1-r7/24da2e766792315b2f4ff2abe5b3ad14 to your computer and use it in GitHub Desktop.
SELECT 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)
FROM fact_asset_vulnerability_instance favi
JOIN dim_vulnerability_solution dvs using (vulnerability_id)
JOIN dim_asset da using (asset_id)
JOIN dim_operating_system dos using (operating_system_id)
JOIN dim_solution ds using (solution_id)
JOIN dim_site_asset dsa using (asset_id)
JOIN dim_site dsi using (site_id)
WHERE solution_id IN (SELECT solution_id
FROM dim_solution_highest_supercedence
WHERE superceding_solution_id IN (SELECT solution_id
FROM dim_solution
WHERE
Lower(summary) LIKE '%remove world write permissions%'))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment