Cisco Cisco Firepower Management Center 4000 Guide Du Développeur
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...