Cisco Cisco Firepower Management Center 2000 Entwickleranleitung

Seite von 180
 
5-2
FireSIGHT System Database Access Guide
 
Chapter 5      Schema: Statistics Tracking Tables 
  Understanding Statistics Tracking Tables
Understanding Statistics Tracking Tables
A table’s name ends with 
current_day
current_month
, or 
current_year
 to indicate the timeframe of its 
data. For example, the 
app_ids_stats_current_
timeframe 
describes 
app_stats_current_day
app_stats_current_month
, and 
app_stats_current_year
. The 
app_stats_current_year
 table stores 
statistics for 360 days; the 
current_month
 table stores for 30 days.
Each time the Defense Center receives raw counts from managed devices in your network, it updates all 
three table types, but does so at successively coarser resolution. The 
current_day
 table has the finest 
resolution (15 seconds or 5 minutes, depending on the particular table); the 
current_year
 table has the 
coarsest resolution (24 hours). See 
specific information.
Storage Characteristics for Statistics Tracking Tables
See the following table for important details.
A storage interval is defined by its start time. For example, the 
current_month
 table contains counts for 
the hour 
10:00:00
 - 
10:59:59
 as one record with a timestamp of 
10:00:00
. Note that a day begins at 
00:00:00
 and ends at 
23:59:59
. Interval start times are stored as UNIX timestamps (GMT). 
Specifying Time Intervals When Querying Statistics Tables
The effective time interval for a query is defined by both the table and the 
time_start_sec
 field in the 
query.
access control and intrusion protection activity, by user.
5.0+
traffic volume and system access control activity 
(connections allowed or denied), by user.
5.0+
Table 5-1
Application and URL Statistics Tables (continued)
See
For the table that stores statistics on...
Version
Table 5-2
Storage Characteristics of Statistics Tables 
Table Type
Interval (Resolution)
Storage Lifespan
current_day
15 seconds for
 
app_ids_stats_current_
timeframe
 and 
user_ids_stats_current_
timeframe
current interval plus all intervals in the 
preceding 24 hours
5 minutes for
 
app_stats_current_
timeframe
user_stats_current_
timeframe
url_category_stats_current_
timeframe
, and 
url_reputation_stats_current_
timeframe
current interval plus all intervals in the 
preceding 24 hours
current_month
one hour
current hour plus the hours stretching back 
30 days
current_year
24 hours
current day plus the preceding 360 days