diff options
| -rw-r--r-- | dbstore/sql/cisa/search.sql | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/dbstore/sql/cisa/search.sql b/dbstore/sql/cisa/search.sql index daaf5cf..01db7a5 100644 --- a/dbstore/sql/cisa/search.sql +++ b/dbstore/sql/cisa/search.sql @@ -2,8 +2,8 @@ SELECT COALESCE(json_group_array(json_object( 'vuln_id', a.vuln_id, 'cve_id', c.nvd_id, - 'vendor', b.vendor, - 'product', b.product, + 'vendor', d.name, + 'product', e.name, 'name', b.name, 'added_at', b.added_at, 'action', b.action, @@ -22,5 +22,9 @@ SELECT COALESCE(json_group_array(json_object( ON (b.vuln_id = a.vuln_id) JOIN cisa_vuln_cve_ids c ON (c.vuln_id = b.vuln_id) + JOIN cisa_vendors d + ON (d.vendor_id = b.vendor_id) + JOIN cisa_products e + ON (e.product_id = b.product_id) ORDER BY a.min_rank; |