Cisco Cisco Firepower Management Center 2000 Guía Del Desarrollador
6-18
FireSIGHT System Database Access Guide
Chapter 6 Schema: Discovery Event and Network Map Tables
rna_host_client_app
rna_host_client_app Sample Query
The following query returns information about the client applications detected on the host with
host_id
of
8
.
SELECT host_id, client_application_id, client_application_name, version, hits,
application_protocol_id, application_protocol_name, last_used_sec
FROM rna_host_client_app
WHERE HEX(host_id) = "00000000000000000000000000000008";
host_id
and
application_protocol_id
and
client_application_id
and
version
the set of:
application_protocol_id
or
client_application_id
Table 6-15
rna_host_client_app Joins (continued)
You can join this table on...
And...