Cisco Cisco Firepower Management Center 4000 Entwickleranleitung

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