Cisco Cisco Firepower Management Center 2000 Entwickleranleitung
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
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.
(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
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
preceding 24 hours
current_month
one hour
current hour plus the hours stretching back
30 days
30 days
current_year
24 hours
current day plus the preceding 360 days