Cisco Cisco Firepower Management Center 2000 Entwickleranleitung

Seite von 180
 
6-48
FireSIGHT System Database Access Guide
 
Chapter 6      Schema: Discovery Event and Network Map Tables 
  rna_host_third_party_vuln
rna_host_service_vulns Joins
The following table describes the joins you can perform on the 
rna_host_service_vulns
 table.
rna_host_service_vulns Sample Query
The following query returns information about all server vulnerabilities for the host with 
host_id
 of 
8
.
SELECT host_id, rna_vuln_id, vendor, service_name, version, invalid FROM 
rna_host_service_vulns 
WHERE HEX(host_id) = "00000000000000000000000000000008";
rna_host_third_party_vuln
The 
rna_host_third_party_vuln
 table contains information on the third-party vulnerabilities associated 
with the hosts in your monitored network. Note that the information in this table is determined by the 
third-party vulnerability data imported via the host input feature.
For more information, see the following sections:
  •
  •
  •
Table 6-42
rna_host_service_vulns Joins 
You can join this table on...
And...
rna_vuln_id
 
 
 
 
host_id