The scheduled_report_log table, The adprovconfig table – HP 3PAR StoreServ 7000 Storage User Manual
Page 195
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.
Table 65 adprovconfig_1 Table
Comment
Type
Column
A unique identifier for each adaptive optimization configuration.
INTEGER PRIMARY KEY
(AUTO_INCREMENT)
adprovid
The system name.
VARCHAR(32) NOT
NULL
sysname
Tier 0 CPG name. If there is no tier 0, this should be the empty string.
VARCHAR(32) NULL
t0_cpg_name
Tier 1 CPG name. If there is no tier 1, this should be the empty string.
VARCHAR(32) NULL
t1_cpg_name
Tier 2 CPG name. If there is no tier 2, this should be the empty string.
VARCHAR(32) NULL
t2_cpg_name
Administrative Tables 195