Cisco Cisco Firepower Management Center 4000 Entwickleranleitung

Seite von 180
 
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