Cisco Cisco Firepower Management Center 4000 Entwickleranleitung
6-33
FireSIGHT System Database Access Guide
Chapter 6 Schema: Discovery Event and Network Map Tables
rna_host_sensor
rna_host_protocol Joins
The following table describes the joins you can perform on the
rna_host_protocol
table.
rna_host_protocol Sample Query
The following query returns all protocol records for the host with
host_id
of
8
.
SELECT protocol_num, protocol_name
FROM rna_host_protocol
WHERE HEX(host_id) = "00000000000000000000000000000008";
rna_host_sensor
The
rna_host_sensor
table lists the host IP addresses in your monitored network and indicates the
managed device that detected each one.
The
rna_host_sensor
table supersedes the deprecated
rna_ip_host_sensor
table starting with Version
5.2 of the FireSIGHT System.
For more information, see the following sections:
•
•
•
Table 6-29
rna_host_protocol Joins
You can join this table on...
And...
host_id