SQL example - asset authentication access level
This example query returns asset credential statuses in terms of authentication access level.
sql
1SELECT ds.name "Site", da.ip_address as "IP Address", da.host_name as "Host Name", dacs.aggregated_credential_status_description "Access Level"23FROM dim_asset da45JOIN fact_asset fa using (asset_id)67JOIN dim_site_asset dsa using (asset_id)89JOIN dim_site ds using (site_id)1011JOIN dim_aggregated_credential_status dacs using (aggregated_credential_status_id)1213GROUP BY ds.name, da.ip_address, da.host_name, dacs.aggregated_credential_status_description1415ORDER BY da.ip_address DESC
Did this page help you?