User Manual v12.3.0 Owner's manual

1518 Brocade Network Advisor IP User Manual
53-1003153-01
Database tables and fields
I
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 36 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
CREATED_BY Indicates which user created the schedule.'; int
EMAIL_DELIVERY Indicates if the generated report needs to be emailed
or not. 0 = Not required, 1 = Required. Default value is
0
int
FOLDER_DELIVERY Indicates if the generated report needs to be placed in
the specified report_store_location or not. 0 = Not
required, 1 = Required. Default value is 0.
int
EMAIL_RECIPIENTS Indicates the generated report email recipients. character 255
EMAIL_FROM Indicates the email from field. character 255
EMAIL_REPLYTO Indicates the email reply to field. character 255
EMAIL_SUBJECT Indicates the email subject. character 255
EMAIL_PROLOGUE Indicates the email body prolog. character 255
EMAIL_EPILOGUE Indicates the email body epilog. character 255
LAST_MODIFIED_TIME Indicates when the schedule was last modified. timestamp
CREATED_TIME Indicates when the schedule was created. timestamp
TABLE 35 BIRTREPORT_RUN_TEMPLATE (Continued)
Field Definition Format Size