HP 3PAR System Reporter Software - Manual (Page 299)

10.7 Administrative Tables
System Reporter 2.8 3PAR System Reporter User’s Guide
10.3.5 The scheduled_report Table
The scheduled_report_1 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 10-5. scheduled_report_1 Table
Column Type Comment
rpt_id INTEGER PRIMARY
KEY
(AUTO_INCREMENT)
A unique identifier for each scheduled
report.
rpt_dir VARCHAR(64) NOT
NULL
The top level report directory (under the
3par/scheduledreports/ directory).
rpt_name VARCHAR(64) NOT
NULL
The report name. A sub-directory of this
name is created (under the rpt_dir
directory) in which all scheduled reports
are created.
rpt_sched VARCHAR(200) NOT
NULL
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. Each of these three lists is either
a “*” or a comma-separated list of
individual dates, weekdays and hours
respectively.
rpt_url VARCHAR(4000) NOT
NULL
The report’s URL parameters (after the
“?” in the URL).
rpt_active INTEGER NOT NULL 0 - Report is not active.
1 - Report is active.