Cisco Cisco Firepower Management Center 2000 Guía Del Desarrollador
3-11
FireSIGHT System Database Access Guide
Chapter 3 Schema: System-Level Tables
sru_import_log
sru_import_log Joins
You cannot perform joins on the
sru_import_log
table.
sru_import_log Sample Query
The following query returns up to 25 results in descending order, sorted by timestamp.
SELECT FROM_UNIXTIME(import_time_sec)
AS time, name, type, action, generator_id, signature_id, revision, policy
FROM sru_import_log
ORDER BY time DESC
LIMIT 0, 25;
sru_uuid
A unique identifier for the rule update.
type
Type of imported object in the rule update:
update
,
rule
,
variable
, and so forth.
Table 3-6
sru_import_log Fields (continued)
Field
Description