Cisco Cisco Firepower Management Center 4000 Entwickleranleitung

Seite von 180
 
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...