Cisco Cisco Firepower Management Center 4000 Entwickleranleitung

The following table describes the joins you can perform on the 

 table.

The following query returns all user activity records for the selected IP address after the specified start 
timestamp.

SELECT ipaddr, start_time_sec, end_time_sec, user_name, user_rna_service, 

user_last_seen_sec, user_last_updated_sec 

FROM user_ipaddr_history 

WHERE HEX(ipaddr) = "00000000000000000000FFFF0A0A0A04" AND start_time_sec >= 

UNIX_TIMESTAMP("2011-10-01 00:00:00");

ipaddr

 

 

 

 

 

 

 

 

 

 

 

 

 

 

user_id