Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2078)

Brocade Network Advisor SAN + IP User Manual 2041
53-1002949-01
Database tables and fields
I
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 115 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 116 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 114 BIRTREPORT_PARAMETER (Continued)
Field Definition Format Size