Cisco Cisco Firepower Management Center 4000 Entwickleranleitung

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