Cisco Cisco Firepower Management Center 2000 Guía Del Desarrollador
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