Cisco Cisco Firepower Management Center 2000 Entwickleranleitung

user_stats_current_timeframe Sample Query

The following query returns up to 25 user records. Each record contains the bytes of inbound and 
outbound traffic, as well as allowed and denied connections over the measurement time interval.

SELECT sensor_name, sensor_address, username, start_time_sec, bytes_in, bytes_out,

connections_allowed, connections_denied 

FROM user_stats_current_year 

WHERE username="username" LIMIT 0, 25;