Cisco Cisco Firepower Management Center 2000 Guia Do Programador

Página de 180
 
6-21
FireSIGHT System Database Access Guide
 
Chapter 6      Schema: Discovery Event and Network Map Tables
  rna_host_ioc_state
rna_host_client_app_payload Sample Query
The following query returns information about the web applications detected on the host with 
host_id
 
of 
8
.
SELECT host_id, web_application_id, web_application_name, version, 
client_application_id, client_application_name 
FROM rna_host_client_app_payload 
WHERE HEX(host_id) = "00000000000000000000000000000008";
rna_host_ioc_state
The 
rna_host_ioc_state
 table stores the IOC state for hosts in your monitored network.
For more information, see the following sections:
  •
  •
  •
the set of:
 
host_id,
application_protocol_id,
client_application_id,
version
the set of:
 
 
 
 
client_application_id
or
web_application_id
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Table 6-17
rna_host_client_app_payload Joins (continued)
You can join this table on...
And...