Cisco Cisco Firepower Management Center 2000 Entwickleranleitung

The following table describes the joins you can perform on the 

 table.

The following query returns up to 25 hosts with their ioc within a specified timespan.

SELECT host_id, ioc_id

FROM rna_host_ioc_state 

WHERE first_seen 

BETWEEN UNIX_TIMESTAMP("2011-10-01 00:00:00") 

AND UNIX_TIMESTAMP("2011-10-07 23:59:59") 

ORDER BY ioc_id DESC 

LIMIT 0, 25;

host_id