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