I currently have a SQL query to export sites names, IP addresses in scope and exclusions. I Am trying to find a way to also export the Scan engine OR the scan engine pool assigned to the site and the IP address for the scan engines. My current Query is:
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)
GROUP BY ds.name, dst.site_id, dst.included, dst.scope