Руководство Разработчика для Cisco Cisco Firepower Management Center 4000
6-28
FireSIGHT System Database Access Guide
Chapter 6 Schema: Discovery Event and Network Map Tables
rna_host_os
rna_host_mac_map Joins
The following table describes the joins you can perform on the
rna_host_mac_map
table.
rna_host_mac_map Sample Query
The following query returns MAC information for the host with
host_id
of
8
.
SELECT HEX(mac_address)
FROM rna_host_mac_map
WHERE HEX(host_id) = "00000000000000000000000000000008";
rna_host_os
The
rna_host_os
table contains information on the operating systems detected on the hosts in your
monitored network.
For more information, see the following sections:
•
•
•
Table 6-23
rna_host_mac_map Joins
You can join this table on...
And...
host_id