Filter
Top Products
Brocade Network Advisor IP User Manual 1515
53-1003056-01
Database tables and fields
I
TABLE 327 REPORT_TYPE
Field Definition Format Size
ID* Meta Data for available reports. int
NAME Report name. varchar 128
DESCRIPTION Report type description. varchar 256
TABLE 328 REPORT_TEMPLATE
Field Definition Format Size
ID The primary key of the table. int
NAME Name of the report and the report names must be
descriptive. For example, Wired Device Report.
varchar 256
TITLE The title of the report that briefly describes the report
contents. This title will also be used for the report
header and menu item. Title should be unique. For
example, Wired Products List.
varchar 256
CREATED_TIME Timestamp of when the report was created. timestamp
CREATED_BY Foreign key to the user table, to identify which user
created the report.
int
REPORT_TYPE 0 = Precanned template which will not be deleted or
edited, 1 = Editable report which can be deleted as
well, 2 = Not Editable report but can be deleted.
int
REPORT_DEFINITION XML representation of the report. text
TABLE 329 REPORT_DRILLDOWN_TEMPLATE
Field Definition Format Size
ID* The primary key of the table. int
REPORT_TEMPLATE_ID References the ID column in the REPORT_TEMPLATE
table.
int
NAME Name of the report. Names should be descriptive so
users will know exactly what kind of report they will be
running or scheduling. E.g. Wired Device Report.
varchar 256
REPORT_DRILLDOWN_DEFI
NITION
XML representation of the report. text
TABLE 330 RESOURCE_FABRIC_MAP
Field Definition Format Size
RESOURCE_GROUP_ID* Resource group ID. int
FABRIC_ID* Fabric ID, which is in the resource group. int
TABLE 331 RESOURCE_GROUP
Field Definition Format Size
ID* Unique generated database identifier. int