HP 3PAR StoreServ 7200 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 195
The scheduled_report_log Table, The adprovconfig Table
View all HP 3PAR StoreServ 7200 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 195 highlights
Table 63 scheduled_report_2 Table Column rpt_id rpt_dir rpt_name rpt_sched rpt_url rpt_active rpt_createtime rpt_retentiondays RPT_EMAIL Type Comment INTEGER PRIMARY KEY A unique identifier for each scheduled report. (AUTO_INCREMENT) VARCHAR(64) NOT NULL The top level report directory (under the 3par/ scheduledreports/ directory). 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. 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. VARCHAR(4000) NOT The report's URL parameters (after the "?" in the URL). NULL INTEGER NOT NULL 0 - Report is not active. 1 - Report is active. VARCHAR(64) NOT NULL The time when this scheduled report was created. INTEGER NOT NULL The number of days for which created reports should be kept. Reports that are older are automatically deleted. VARCHAR(1000) COMMA SEPARATED The email address for delivery of scheduled reports. 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 Column rpt_id rpt_run_start_time rpt_run_end_time rpt_run_hr rpt_run_status Type INTEGER PRIMARY KEY (AUTO_INCREMENT) VARCHAR(64) NOT NULL VARCHAR(64) NOT NULL INTEGER INTEGER Comment A unique identifier for each scheduled report. The time the report was started. The time the report finished executing. The hour that the report ran. The status for the report. The adprovconfig Table The adprovconfig_1 table has a row for each adaptive optimization configuration. Table 65 adprovconfig_1 Table Column adprovid sysname t0_cpg_name t1_cpg_name t2_cpg_name Type Comment INTEGER PRIMARY KEY A unique identifier for each adaptive optimization configuration. (AUTO_INCREMENT) VARCHAR(32) NOT NULL The system name. VARCHAR(32) NULL Tier 0 CPG name. If there is no tier 0, this should be the empty string. VARCHAR(32) NULL Tier 1 CPG name. If there is no tier 1, this should be the empty string. VARCHAR(32) NULL Tier 2 CPG name. If there is no tier 2, this should be the empty string. Administrative Tables 195