Cisco Cisco Firepower Management Center 2000 Guia Do Programador

Página de 180
 
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