Created
November 27, 2018 14:43
-
-
Save jfrantz1-r7/24da2e766792315b2f4ff2abe5b3ad14 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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