Brocade Communications Systems IP250 Reporttype, Reporttemplate, Reportdrilldowntemplate

	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	varchar	256
	descriptive. For example, Wired Device Report.
TITLE	The title of the report that briefly describes the report	varchar	256
	contents. This title will also be used for the report
	header and menu item. Title should be unique. For
	example, Wired Products List.
CREATED_TIME	Timestamp of when the report was created.	timestamp
CREATED_BY	Foreign key to the user table, to identify which user	int
	created the report.
REPORT_TYPE	0 = Precanned template which will not be deleted or	int
	edited, 1 = Editable report which can be deleted as
	well, 2 = Not Editable report but can be deleted.
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	int
	table.
NAME	Name of the report. Names should be descriptive so	varchar	256
	users will know exactly what kind of report they will be
	running or scheduling. E.g. Wired Device Report.
REPORT_DRILLDOWN_DEFI	XML representation of the report.	text
NITION
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

Brocade Network Advisor IP User Manual	1515
53-1003056-01