Cisco Cisco Firepower Management Center 2000 Entwickleranleitung

Seite von 180
 
6-58
FireSIGHT System Database Access Guide
 
Chapter 6      Schema: Discovery Event and Network Map Tables 
  tag_info
rna_vuln Sample Query
The following query returns information about up to 25 vulnerabilities. The records are sorted in order 
of most events generated based on the vulnerability.
SELECT rna_vuln_id, bugtraq_id, snort_id, title, publish_date, impact, remote, exploit, 
long_description, technical_description, solution, count(*) as count 
FROM rna_vuln 
GROUP BY rna_vuln_id 
ORDER BY rna_vuln_id DESC LIMIT 0, 25;
tag_info
The 
tag_info
 table contains information on the tags that are associated with the applications detected 
on your network. Note that an application can have multiple associated tags.
For more information, see the following sections:
  •
  •
  •
tag_info Fields
The following table describes the fields you can access in the 
tag_info
 table.
tag_info Joins
The following table describes the joins you can perform on the 
tag_info
 table.
Table 6-53
tag_info Fields 
Field
Description
tag_description
Tag description.
tag_id
Internal identifier for the tag.
tag_name
Text of the tag that appears in the user interface.
tag_type
One of the following:
  •
category 
  •
tag
Table 6-54
tag_info Joins 
You can join this table on...
And...
tag_id