Cisco Cisco Firepower Management Center 2000 Entwickleranleitung
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.
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