Cisco Cisco Firepower Management Center 2000 개발자 가이드

다운로드
페이지 180
 
6-32
FireSIGHT System Database Access Guide
 
Chapter 6      Schema: Discovery Event and Network Map Tables 
  rna_host_protocol
rna_host_os_vulns Sample Query
The following query returns the operating system vulnerabilities for the host with 
host_id
 of 
8
.
SELECT rna_vuln_id, invalid 
FROM rna_host_os_vulns 
WHERE HEX(host_id) = "00000000000000000000000000000008";
rna_host_protocol
The 
rna_host_protocol
 table contains information on the protocols detected on the hosts in your 
monitored network.
For more information, see the following sections:
  •
  •
  •
rna_host_protocol Fields
The following table describes the fields you can access in the 
rna_host_protocol
 table.
Table 6-28
rna_host_protocol Fields 
Field
Description
host_id
ID number of the host.
ip_address
Field deprecated in Version 5.2. Returns 
null
 for all queries.
layer
The network layer where the protocol is running: 
Network
 or 
Transport
.
mac_address
Field deprecated in Version 5.2. Returns 
null
 for all queries.
mac_vendor
Field deprecated in Version 5.2. Returns 
null
 for all queries.
protocol_name
The traffic protocol used by the host.
protocol_num
The IANA-specified protocol number for the protocol.