Cisco Cisco Firepower Management Center 2000 Guia Do Programador

Página de 180
 
6-42
FireSIGHT System Database Access Guide
 
Chapter 6      Schema: Discovery Event and Network Map Tables 
  rna_host_service_info
rna_host_service_info Sample Query
The following query returns information about the application protocols detected on the host with 
host_id
 of 
8
.
SELECT host_id, application_protocol_name, version, vendor, created_sec, last_used_sec, 
business_relevance, risk 
FROM rna_host_service_info 
WHERE HEX(host_id) = "00000000000000000000000000000008";
host_id
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
The set of:
 
host_id
and
port
and
protocol
The set of:
 
 
 
The set of:
 
 
The set of:
 
Table 6-37
rna_host_service_info Joins (continued)
You can join this table on...
And...