Cisco Cisco Firepower Management Center 2000 Entwickleranleitung

The following query returns up to 25 connection event records from the 

 table, sorted 

in descending order based on packet timestamps.

SELECT first_packet_sec, last_packet_sec, initiator_ipaddr, responder_ipaddr, 

security_zone_ingress_name, security_zone_egress_name, initiator_port, protocol_name, 

responder_port, application_protocol_id, client_application_id, web_application_id, url, 

url_category, url_reputation 

FROM si_connection_log

WHERE first_packet_sec <= UNIX_TIMESTAMP("2011-10-01 00:00:00") ORDER BY 

first_packet_sec 

DESC, last_packet_sec DESC LIMIT 0, 25;