6 the scheduled_report_log table, 7 the adprovconfig table, The scheduled_report_log table – HP 3PAR System Reporter Software User Manual

Page 301: The adprovconfig table

Advertising
background image

10.9

Administrative Tables

System Reporter 2.8

3PAR System Reporter User’s Guide

10.3.6 The scheduled_report_log Table

The scheduled_report_log_1 table is used to keep track of when each scheduled report has

run.

10.3.7 The adprovconfig Table

The adprovconfig_1 table has a row for each adaptive optimization configuration.

Table 10-6. scheduled_report_log_1 Table

Column

Type

Comment

rpt_id

INTEGER PRIMARY

KEY

(AUTO_INCREMENT)

A unique identifier for each scheduled

report.

rpt_run_start_time

VARCHAR(64) NOT

NULL

The time the report was started.

rpt_run_end_time

VARCHAR(64) NOT

NULL

The time the report finished

executing.

rpt_run_hr

INTEGER

The hour that the report ran.

rpt_run_status

INTEGER

The status for the report.

Table 10-7. adprovconfig_1 Table

Column

Type

Comment

adprovid

INTEGER PRIMARY

KEY

(AUTO_INCREMENT)

A unique identifier for each adaptive

optimization configuration.

sysname

VARCHAR(32) NOT

NULL

The InServ system name.

Advertising