unauthenticated assets

 SELECT dsite."name"    AS "Site",
       da.ip_address,
       da.host_name,
       dos.description AS "OS",
       os.certainty_max
FROM   fact_asset AS fa
       JOIN dim_asset da
         ON da.asset_id = fa.asset_id
       JOIN (SELECT asset_id,
                    Max(certainty) AS certainty_max
             FROM   dim_asset_operating_system
             GROUP  BY asset_id) os
         ON fa.asset_id = os.asset_id
            AND os.certainty_max < 1
       JOIN dim_operating_system AS dos
         ON da.operating_system_id = dos.operating_system_id
       JOIN dim_site_asset AS dsa
         ON fa.asset_id = dsa.asset_id
       JOIN dim_site AS dsite
         ON dsa.site_id = dsite.site_id
GROUP  BY dsite."name",
          da.ip_address,
          da.host_name,
          dos.description,
          os.certainty_max
ORDER  BY "site",
          da.ip_address