SQL example - authentication level achieved with current credentials
This example query returns what authentication levels assets are receiving during scans. This will show the site, asset, IP and hostname with service, protocol and access level.
sql
1SELECT dsite.name "Site", da.ip_address as "IP Address", da.host_name as "Host Name", ds.name as "Service", dp.description as "Protocol", dcs.credential_status_description "Access Level"23FROM dim_asset da45JOIN fact_asset_scan_service fass using (asset_id)67JOIN fact_asset fa using (asset_id)89JOIN dim_site_asset dsa using (asset_id)1011JOIN dim_site dsite using (site_id)1213JOIN dim_service ds using (service_id)1415JOIN dim_protocol dp using (protocol_id)1617JOIN dim_credential_status dcs using (credential_status_id)1819GROUP BY dsite.name, da.ip_address, da.host_name, ds.name, dp.description, dcs.credential_status_description2021ORDER BY da.ip_address DESC
Did this page help you?