Cisco Cisco Firepower Management Center 4000 Developer's Guide
6-53
FireSIGHT System Database Access Guide
Chapter 6 Schema: Discovery Event and Network Map Tables
rna_host_third_party_vuln_rna_id
rna_host_third_party_vuln_cve_id Joins
The following table describes the joins you can perform on the
rna_host_third_party_vuln_cve_id
table.
rna_host_third_party_vuln_cve_id Sample Query
The following query returns the CVE vulnerabilities for the host with
host_id
of
8
.
SELECT host_id, third_party_vuln_id, cve_id, name, description, source, invalid
FROM rna_host_third_party_vuln_cve_id
WHERE HEX(host_id) = "00000000000000000000000000000008";
rna_host_third_party_vuln_rna_id
The
rna_host_third_party_vuln_rna_id
table contains information on third-party vulnerabilities that
are mapped to vulnerabilities in the Cisco vulnerability database (VDB) and also associated with hosts
in your monitored network. Note that the third-party vulnerability data in this table is imported via the
host input feature.
in your monitored network. Note that the third-party vulnerability data in this table is imported via the
host input feature.
For more information, see the following sections:
•
•
•
Table 6-48
rna_host_third_party_vuln_cve_id Joins
You can join this table on...
And...
cve_id
host_id