Esteban
08/12/2021, 1:40 PMsql: Scan error on column index 5, name "vulnerabilities": json: cannot unmarshal object into Go value of type fleet.VulnerabilitiesSlice
Tomas Touceda
08/12/2021, 3:02 PMEsteban
08/12/2021, 3:29 PMTomas Touceda
08/12/2021, 3:31 PMSELECT s.id, s.name, s.version, s.source, coalesce(scp.cpe, "") as generated_cpe,
IF(
JSON_ARRAYAGG(scv.cve) = JSON_ARRAYAGG(null),
null,
JSON_ARRAYAGG(
JSON_OBJECT(
"cve", scv.cve,
"details_link", CONCAT('<https://nvd.nist.gov/vuln/detail/>', scv.cve)
)
)
) as vulnerabilities FROM software s
LEFT JOIN software_cpe scp ON (s.id=scp.software_id)
LEFT JOIN software_cve scv ON (scp.id=scv.cpe_id)
group by s.id, s.name, s.version, s.source, generated_cpe
?Esteban
08/12/2021, 3:35 PMTomas Touceda
08/12/2021, 3:38 PMEsteban
08/12/2021, 3:55 PMTomas Touceda
08/12/2021, 3:58 PMEsteban
08/12/2021, 4:00 PMTomas Touceda
08/12/2021, 4:03 PMEsteban
08/12/2021, 5:26 PMTomas Touceda
08/12/2021, 5:28 PMEsteban
08/12/2021, 5:30 PM