Cisco Cisco Firepower Management Center 4000 Entwickleranleitung

Seite von 180
 
6-14
FireSIGHT System Database Access Guide
 
Chapter 6      Schema: Discovery Event and Network Map Tables 
  rna_host_attribute
rna_host Joins
The following table describes the joins you can perform on the 
rna_host
 table.
rna_host Sample Query
The following query returns 25 
rna_host
 records that include the host ID, VLAN ID, when the host was 
last seen, and the type of host, ordered by the type of host.
SELECT host_id, vlan_id, last_seen_sec, host_type
FROM rna_host 
ORDER BY host_type
LIMIT 0, 25;
rna_host_attribute
The 
rna_host_attribute
 table contains information on the host attributes associated with each host in 
your monitored network. It supersedes the deprecated 
rna_ip_host_attribute 
table.
For more information, see the following sections:
  •
  •
  •
Table 6-11
rna_host Joins 
You can join this table on...
And...
host_id