SQL example - sites with credentials issues
This example query is one of the ways to get an idea on what assets have poorly managed credentials such as default accounts.
sql
1SELECT ds.name AS site, da.ip_address, da.host_name, dv.title AS vulnerability_title, dos.description AS operating_system, dos.cpe23FROM fact_asset_vulnerability_finding favf45JOIN dim_asset da USING (asset_id)67JOIN dim_operating_system dos USING (operating_system_id)89JOIN dim_vulnerability dv USING (vulnerability_id)1011JOIN dim_vulnerability_category dvc USING (vulnerability_id)1213JOIN dim_site_asset dsa USING (asset_id)1415JOIN dim_site ds USING (site_id)1617WHERE (dvc.category_name LIKE '%Default Account%')1819ORDER BY ds.name ASC, dv.title ASC
Did this page help you?