The scheduled_report table, The scheduled_report_log table, The adprovconfig table – HP 3PAR System Reporter Software User Manual
Page 193
Table 62 alertconfig_2 Table (continued)
Comment
Type
Column
Defines an additional condition that must be met for certain alerts
to be generated. See
VARCHAR(32)
condition_code
Defines a value used in conjunction with condition_code. See
.
DOUBLE PRECISION
NOT NULL
condition_val
The email address to which alerts for this rule should be sent.
VARCHAR(64)
recipient
The scheduled_report Table
The scheduled_report_2 table contains a row for each scheduled report and defines where the
report should be stored, when it should be run and parameters used to generate the report.
Table 63 scheduled_report_2 Table
Comment
Type
Column
A unique identifier for each scheduled report.
INTEGER PRIMARY KEY
(AUTO_INCREMENT)
rpt_id
The top level report directory (under the 3par/
scheduledreports/
directory).
VARCHAR(64) NOT NULL
rpt_dir
The report name. A sub-directory of this name is created (under
the rpt_dir directory) in which all scheduled reports are created.
VARCHAR(64) NOT NULL
rpt_name
The schedule for this report. The format is a space-separated list
of three items: the date list, the weekday list and the hour list.
VARCHAR(200) NOT
NULL
rpt_sched
Each of these three lists is either a “*” or a comma-separated list
of individual dates, weekdays and hours respectively.
The report’s URL parameters (after the “?” in the URL).
VARCHAR(4000) NOT
NULL
rpt_url
0 - Report is not active. 1 - Report is active.
INTEGER NOT NULL
rpt_active
The time when this scheduled report was created.
VARCHAR(64) NOT NULL
rpt_createtime
The number of days for which created reports should be kept.
Reports that are older are automatically deleted.
INTEGER NOT NULL
rpt_retentiondays
The email address for delivery of scheduled reports.
VARCHAR(1000)
COMMA SEPARATED
RPT_EMAIL
The scheduled_report_log Table
The scheduled_report_log_1 table is used to keep track of when each scheduled report has run.
Table 64 scheduled_report_log_1 Table
Comment
Type
Column
A unique identifier for each scheduled
report.
INTEGER PRIMARY KEY
(AUTO_INCREMENT)
rpt_id
The time the report was started.
VARCHAR(64) NOT NULL
rpt_run_start_time
The time the report finished executing.
VARCHAR(64) NOT NULL
rpt_run_end_time
The hour that the report ran.
INTEGER
rpt_run_hr
The status for the report.
INTEGER
rpt_run_status
The adprovconfig Table
The adprovconfig_1 table has a row for each adaptive optimization configuration.
Administrative Tables
193