Cisco Cisco Firepower Management Center 4000 Entwickleranleitung
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