Cisco Cisco Firepower Management Center 4000 Entwickleranleitung

Seite von 180
 
6-30
FireSIGHT System Database Access Guide
 
Chapter 6      Schema: Discovery Event and Network Map Tables 
  rna_host_os_vulns
rna_host_os Joins
The following table describes the joins you can perform on the 
rna_host_os
 table.
rna_host_os Sample Query
The following query returns operating system information for the host with 
host_id
 of 
8
.
SELECT vendor, product, version, source_type, confidence 
FROM rna_host_os 
WHERE HEX(host_id) = "00000000000000000000000000000008";
rna_host_os_vulns
The 
rna_host_os_vulns
 table contains information on the vulnerabilities associated with the hosts in 
your monitored network. 
For more information, see the following sections:
  •
  •
  •
Table 6-25
rna_host_os Joins 
You can join this table on...
And...
host_id