Cisco Cisco Firepower Management Center 4000 Entwickleranleitung
6-27
FireSIGHT System Database Access Guide
Chapter 6 Schema: Discovery Event and Network Map Tables
rna_host_mac_map
rna_host_ip_map Sample Query
The following query returns MAC information for the selected host.
SELECT host_id
FROM rna_host_ip_map
WHERE HEX(ipaddr) = "00000000000000000000FFFF0A0A0A04";
rna_host_mac_map
The
rna_host_mac_map
table correlates host IDs to MAC addresses for hosts in your monitored network.
For more information, see the following sections:
•
•
•
rna_host_mac_map Fields
The following table describes the fields you can access in the
rna_host_mac_map
table.
Table 6-22
rna_host_mac_map Fields
Field
Description
host_id
ID number of the host.
mac_address
The host’s MAC address.
mac_vendor
Vendor of the network interface of the detected host.