Cisco Cisco Firepower Management Center 2000 Guia Do Programador

Página de 180
 
6-51
FireSIGHT System Database Access Guide
 
Chapter 6      Schema: Discovery Event and Network Map Tables
  rna_host_third_party_vuln_cve_id
rna_host_third_party_vuln_bugtraq_id Joins
The following table describes the joins you can perform on the 
rna_host_third_party_vuln_bugtraq_id
 table.
rna_host_third_party_vuln_bugtraq_id Sample Query
The following query returns the BugTraq vulnerabilities for the host with 
host_id
 of 
8
.
SELECT host_id, third_party_vuln_id, bugtraq_id, name, description, source, invalid 
FROM rna_host_third_party_vuln_bugtraq_id 
WHERE HEX(host_id) = "00000000000000000000000000000008";
rna_host_third_party_vuln_cve_id
The 
rna_host_third_party_vuln_cve_id
 table contains information on the third-party vulnerabilities 
that are mapped to vulnerabilities in MITRE’s CVE database and also associated with the hosts in your 
monitored network. Note that this table contains third-party vulnerability data imported via the host 
input feature.
For more information, see the following sections:
  •
  •
  •
Table 6-46
rna_host_third_party_vuln_bugtraq_id Joins 
You can join this table on...
And...
bugtraq_id
 
 
 
host_id