Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Brocade Network Advisor SAN User Manual 1333
53-1002948-01
Database tables and fields
H
DATA_TYPE Data type of the parameter. Possible values are:
• 1 - String
• 2 - Float
• 3 - Decimal
• 4 - Date and Time
• 5 - Boolean
• 6 - Integer
• 7 - Date
• 8 - Time
int
PARAMETER_VALUE Value of the Parameter. varchar 256
TABLE 100 BIRTREPORT_RUN_TEMPLATE
Field Definition Format Size
ID The primary key of the table. int
SCHEDULE_ID References the ID column in the
BIRTREPORT_SCHEDULE_CONFIG table.
int
REPORT_TEMPLATE_TITLE Report Template title. This name is the same as the
title name in the REPORT_TEMPLATE table. There is no
foreign key relation here as the user may delete and
add a template but the schedule should still hold good
if looked up by title. Also title is unique in the
REPORT_TEMPLATE table.
varchar 256
NAME Name of the generated report file. varchar 256
TABLE 101 BIRTREPORT_SCHEDULE_CONFIG
Field Definition Format Size
ID The primary key of the table. int
DEPLOYMENT_ID References the ID column in the
DEPLOYMENT_CONFIGURATION table.
int
NAME Name of the schedule. varchar 128
REPORT_STORE_LOCATION Path to the location where the generated report files
are stored.
varchar 256
OVERWRITE 0 and 1 are allowed values.1 indicates overwrite is
true. I.e., every run of the schedule will overwrite the
previous output.0 indicates archive. I.e., every run of
the schedule will create a new folder in the store
location with timestamp to ensure that output of all the
runs will be archived.
int
FORMAT_TYPE Possible values are 0, 1, and 2.
• 0 indicates output will be in HTML
• 1 indicates PDF
• 2 indicates CSV
int
TABLE 99 BIRTREPORT_PARAMETER (Continued)
Field Definition Format Size