diff options
| author | Paul Duncan <pabs@pablotron.org> | 2022-03-18 00:39:13 -0400 |
|---|---|---|
| committer | Paul Duncan <pabs@pablotron.org> | 2022-03-18 00:39:13 -0400 |
| commit | e9df9a34d4eb229af52520d7a8aced08cc420a44 (patch) | |
| tree | 481a9f1f6a3b7d14ea18cd827446781a9dbfc432 | |
| parent | f955afc850693247dccb70bf470a3c88b6109b94 (diff) | |
| download | cvez-e9df9a34d4eb229af52520d7a8aced08cc420a44.tar.bz2 cvez-e9df9a34d4eb229af52520d7a8aced08cc420a44.zip | |
dbstore/sql/cisa/search.sql: fix vendor and product names
| -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; |