Cisco Cisco Firepower Management Center 4000 Entwickleranleitung

transmission_stats_by_file_type_current_timeframe Joins

You cannot perform joins on the 

 tables.

transmission_stats_by_file_type_current_timeframe Sample Query

The following query returns the number of dropped and sent connections for each sensor, in descending 
order by 

file_type

 during the current day.

SELECT sensor_name, number_dropped, number_sent, file_type

FROM transmission_stats_by_file_type_current_day

ORDER BY file_type DESC;

url_category_stats_current_timeframe

The 

 tables contain statistics on the bandwidth usage and 

connections associated with requests to URLs in specified URL categories. You can also constrain 
queries on the managed device that monitored the traffic.

For an understanding of the 

, 

, and 

 statistics tables, see 

.

For more information on the 

 tables, see the following sections:

number_dropped

Number of files of this type dropped.

number_sent

Number of files of this type sent.

sensor

ID of the device that detected the file.

sensor_address

The IP address of the managed device that generated the event. Format is 

.

sensor_name

The name of the managed device that generated the intrusion event.

sensor_uuid

A unique identifier for the managed device, or 

0

 if 

sensor_name

 is 

null

.

start_time_sec

The UNIX timestamp of the date and time the measurement interval starts. 
For detailed information, see 

.