User Manual v12.3.0 Owner's manual

Brocade Network Advisor IP User Manual 1663
53-1003153-01
Database tables and fields
I
TABLE 335 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
PARAMETERIZED int
CATEGORY Indicates the report template category. 0 = SAN
domain, 1 = IP domain. Default value is 0.
int
SHARED Indicates if the report template is shared or not. 0 =
Not shared, 1 = Shared. Default value is 0.
int
TABLE 336 REPORT_TEMPLATE_FAVORITE
Field Definition Format Size
FAVORITED_BY_USER_ID Indicates the user ID of the user who favorited this
report template.
int
FAVORITED_REPORT_TEMP
LATE_ID
Indicates the favorited report template ID. int
TABLE 337 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