Cisco Cisco Firepower Management Center 2000 Guía Del Desarrollador
6-32
FireSIGHT System Database Access Guide
Chapter 6 Schema: Discovery Event and Network Map Tables
rna_host_protocol
rna_host_os_vulns Sample Query
The following query returns the operating system vulnerabilities for the host with
host_id
of
8
.
SELECT rna_vuln_id, invalid
FROM rna_host_os_vulns
WHERE HEX(host_id) = "00000000000000000000000000000008";
rna_host_protocol
The
rna_host_protocol
table contains information on the protocols detected on the hosts in your
monitored network.
For more information, see the following sections:
•
•
•
rna_host_protocol Fields
The following table describes the fields you can access in the
rna_host_protocol
table.
Table 6-28
rna_host_protocol Fields
Field
Description
host_id
ID number of the host.
ip_address
Field deprecated in Version 5.2. Returns
null
for all queries.
layer
The network layer where the protocol is running:
Network
or
Transport
.
mac_address
Field deprecated in Version 5.2. Returns
null
for all queries.
mac_vendor
Field deprecated in Version 5.2. Returns
null
for all queries.
protocol_name
The traffic protocol used by the host.
protocol_num
The IANA-specified protocol number for the protocol.