When i run the next SQL Query i obtain the information required but always export with duplicates, I’m not a expert on SQL so i hope you could help me.
SELECT
dsite.name AS “Site Name”,
da.ip_address AS “IP Address”,
da.host_name AS “Host Name”,
dv.title AS “Vulnerabiltiy”,
dv.description AS “Vulnerability Description”,
dv.severity AS “Severity”,
dv.cvss_score AS “CVSS”,
ds.url AS “URL”,
ds.solution_type AS “Solution Type”,
ds.summary AS “Solution”,
fv.first_discovered AS “First Discovered”
FROM
fact_asset_vulnerability_instance AS fav
JOIN fact_vulnerability AS fv ON fav.vulnerability_id = fv.vulnerability_id
JOIN dim_vulnerability AS dv ON fav.vulnerability_id = dv.vulnerability_id
JOIN dim_site_asset AS dsa ON fav.asset_id = dsa.asset_id
JOIN dim_site AS dsite ON dsa.site_id = dsite.site_id
JOIN dim_ASset AS da ON fav.asset_id = da.asset_id
JOIN dim_vulnerability_solution AS dvs ON fv.vulnerability_id = dvs.vulnerability_id
JOIN dim_solution AS ds ON dvs.solution_id = ds.solution_id
GROUP by
dsite.name,
da.ip_address,
da.host_name,
dv.title,
dv.severity,
dv.cvss_score,
ds.solution_type,
ds.summary,
dv.description,
ds.url,
fv.first_discovered
ORDER by
dsite.name ASC