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

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 sub-directory of this

 

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 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

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