SQL example - unauthenticated/unmanaged assets
sql
1SELECT dsite."name" as "Site", da.ip_address, da.host_name, dos.description as "OS", os.certainty_max23FROM fact_asset AS fa45JOIN dim_asset da ON da.asset_id = fa.asset_id67JOIN (89SELECT asset_id, MAX(certainty) as certainty_max1011FROM dim_asset_operating_system1213GROUP BY asset_id1415) os ON fa.asset_id = os.asset_id AND os.certainty_max < 11617JOIN dim_operating_system as dos1819ON da.operating_system_id = dos.operating_system_id2021JOIN dim_site_asset as dsa2223ON fa.asset_id = dsa.asset_id2425JOIN dim_site as dsite2627ON dsa.site_id = dsite.site_id2829GROUP BY dsite."name", da.ip_address, da.host_name,dos.description, os.certainty_max3031ORDER BY "Site", da.ip_address
Did this page help you?