aboutsummaryrefslogtreecommitdiff
path: root/dbstore/sql
diff options
context:
space:
mode:
authorPaul Duncan <pabs@pablotron.org>2022-03-18 00:39:13 -0400
committerPaul Duncan <pabs@pablotron.org>2022-03-18 00:39:13 -0400
commite9df9a34d4eb229af52520d7a8aced08cc420a44 (patch)
tree481a9f1f6a3b7d14ea18cd827446781a9dbfc432 /dbstore/sql
parentf955afc850693247dccb70bf470a3c88b6109b94 (diff)
downloadcvez-e9df9a34d4eb229af52520d7a8aced08cc420a44.tar.bz2
cvez-e9df9a34d4eb229af52520d7a8aced08cc420a44.zip
dbstore/sql/cisa/search.sql: fix vendor and product names
Diffstat (limited to 'dbstore/sql')
-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;