aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--dbstore/sql/cisa/search.sql8
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;