select ds.name AS “Site Name”, dst.site_id AS “Site ID”, dst.included AS “Included”, dst.scope AS “Exclusion Level”, string_agg(dst.target::character varying, ’ | ') AS “Target”
from dim_site_target dst
JOIN dim_site ds USING(site_id)
JOIN dim_site_scan USING (site_id)
JOIN dim_scan USING (scan_id)
GROUP BY ds.name, dst.site_id, dst.included, dst.scope
Hi All, I think I am working with an outdated schema map for the insightvm console so I am going to ask for the most updated version. In the meantime I was hoping to receive some help with the above query. I would like to add the scan engine IP the site is using and the next time the site is supposed to run a scan. Thank you for your help!