SQL Query Example: Asset Authentication Access Level

Document created by synapsr on Feb 6, 2015
Version 1Show Document
  • View in full screen mode

On the subject of credentials, sometimes it is useful to report on asset credential status in terms of authentication access level




SELECT ds.name "Site", da.ip_address as "IP Address", da.host_name as "Host Name", dacs.aggregated_credential_status_description "Access Level"

FROM dim_asset da

JOIN fact_asset fa using (asset_id)

JOIN dim_site_asset dsa using (asset_id)

JOIN dim_site ds using (site_id)

JOIN dim_aggregated_credential_status dacs using (aggregated_credential_status_id)

GROUP BY ds.name, da.ip_address, da.host_name, dacs.aggregated_credential_status_description

ORDER BY da.ip_address DESC

2 people found this helpful