Accessing data using public views
A data mart is a subset of the data warehouse that is usually oriented to a specific business line or team. Data marts can be used to prepare data for a custom view or report. For information about managing data marts, see SQL-based data marts.
Data marts rely on a basic set of views that hide the BMC Helix Capacity Optimization data model and expose a more report-oriented view over data, known as public views. The Advanced Reporting module produces a number of public views that can be accessed using the CPIT_REP account (the default database user account for generating reports).
These views let you access relevant BMC Helix Capacity Optimization data in a simple and straightforward manner. The following sections describe these views in detail.
To view example queries developed using these public views, see Query Examples.
Public views produced by the Advanced Reporting module
Public views produced by the Advanced Reporting module that can be accessed using the CPIT_REP account are divided into the following categories:
System-related views
PV_SYSTEM
Each System is created by a connector, and it remains in BMC Helix Capacity Optimization until either all of its data ages out, or the System and all of its data is explicitly dismissed and deleted by a user.This view contains one row for each system, keyed by its unique entity ID (SYSID).
Column Name | Data Type | Description | Key column |
|---|---|---|---|
SYSID | NUMBER | Internal BMC Helix Capacity Optimization-assigned unique identifier | PK |
NAME | VARCHAR2 (50 Bytes) | System name assigned by connector or modified by user | |
DESCRIPTION | VARCHAR2 (250 Bytes) | System description | |
SYSTYPEID | NUMBER | The type of the system, assigned by connector. A constant from the list of System types described in "Entity Types". | |
SYSTYPE | VARCHAR2 (50 Bytes) | Type string that goes with SYSTYPEID | |
CLUSTERID | NUMBER | (deprecated) System cluster ID | |
CLUSTERNAME | VARCHAR2 (50 Bytes) | (deprecated) Cluster name | |
CLUSTERTYPE | VARCHAR2 (25 Bytes) | (deprecated) Cluster type | |
CLUSTERDESCRIPTION | VARCHAR2 (250 Bytes) | (deprecated) Cluster description | |
| STATUSID | NUMBER | Status ID of the system |
PV_SYS_METRIC
This view contains information on metric instances belonging to systems.
A metric instance contains time-varying data, either as a time series of numbers that can change on a frequent interval, or as a configuration string that changes only occasionally. For more information on metrics and metric instances, see Capacity Agent metric groups and metrics.
A metric instance is created when data for a particular metric for a System is first loaded by a connector. It remains in BMC Helix Capacity Optimization until its owning system is either aged out or dismissed and deleted by a user.
This view does not contain the time series or configuration data itself. Time series data is in the PV_SYS_DATA_DETAIL and similar views. Configuration data is in PV_SYS_CONF_LAST and PV_SYS_CONF_VARIATION views.
This view contains one row per metric instance, keyed by SYSMETRICID.
Column Name | Data Type | Description | Key column |
|---|---|---|---|
SYSID | NUMBER | The identifier of the System that the metric instance belongs to, as in PV_SYSTEM. | AK1. FK SYSID in PV_SYSTEM |
SYSMETRICID | NUMBER | An internal unique BMC Helix Capacity Optimization-generated identifier for the metric instance | PK |
NAME | VARCHAR2 (50 Bytes) | System name, as in PV_SYSTEM | |
DESCRIPTION | VARCHAR2 (250 Bytes) | Description string that goes with the System, as in PV_SYSTEM | |
SYSTYPEID | NUMBER | System type ID, as in PV_SYSTEM | |
SYSTYPE | VARCHAR2 (50 Bytes) | Type of the System, as in PV_SYSTEM | |
METRIC | VARCHAR2 (50 Bytes) | Metric name, uniquely identifying the metric of this metric instance | |
METRICNAME | VARCHAR2 (50 Bytes) | Metric full name | |
SUBMETRICNAME | VARCHAR2 (512 Bytes) | Metric sub-object name, valid only for metrics with sub-objects | AK1 |
LOCATIONID | NUMBER | Location ID for the metric instance, if any; default 0 | |
LOCATIONNAME | VARCHAR2 (50 Bytes) | Location name that goes with the location ID, if any; default UNKNOWN | |
VALTYPEID | NUMBER | Value type ID for time series metrics (see table of metric value types). For conf series metrics, the VALTYPEID is always 5. See PV_CAT_VAL_TYPE. | |
VALTYPE | VARCHAR2 (50 Bytes) | Value type (count, rate,..) that goes with the Value type ID |
The 5-tuple structure of a metric instance listed in Capacity Agent metric groups and metrics is a synonym table for the above view, with key series attributes corresponding to the above column names as follows:
Key series attribute | Column name |
|---|---|
ENTITY | SYSID |
ENTCATNM | Not listed (it is always the constant "SYS") |
OBJECT | METRIC |
SUBOBJECT | SUBMETRICNAME |
LOCATION | LOCATIONID |
This table shows how connector data corresponds to the public view.
PV_SYS_EVENT
This view contains information on system events.Column Name | Data Type | Description |
|---|---|---|
SYSDESC | VARCHAR2 (4000 Bytes) | |
SYSTYPEID | NUMBER | |
SYSTYPE | VARCHAR2 (50 Bytes) | |
CLUSTERID | NUMBER | |
CLUSTERNAME | VARCHAR2 (50 Bytes) | |
CLUSTERTYPE | VARCHAR2 (25 Bytes) | |
CLUSTERDESCRIPTION | VARCHAR2 (250 Bytes) | |
TS | DATE | Timestamp |
EVENTTYPEID | NUMBER | |
EVENTTYPENAME | VARCHAR2 (50 Bytes) | |
EVENTSUBTYPEID | NUMBER | |
EVENTSUBTYPENAME | VARCHAR2 (50 Bytes) | |
EVENTID | NUMBER | |
EVENTTS | DATE | |
INTERVENTTS | DATE | |
RESOLUTIONTS | DATE | |
EVENTNAME | VARCHAR2 (250 Bytes) | |
EVENTDESC | VARCHAR2 (4000 Bytes) | |
NOTE | VARCHAR2 (4000 Bytes) | |
COLOR | VARCHAR2 (50 Bytes) | |
PERIOD | NUMBER | |
PERIODSINCEDATE | DATE | |
PERIODTODATE | DATE | |
SEVERITY | VARCHAR2 (50 Bytes) | |
STATUS | VARCHAR2 (50 Bytes) | |
SERVICEUNAVAILABILITY | NUMBER | |
PENDINGTIMEMILLIS | NUMBER | |
INTERVENTTIMEMILLIS | NUMBER | |
RESOLUTIONTIMEMILLIS | NUMBER | |
SOURCECLASS | VARCHAR2 (512 Bytes) | |
SRCEVENTID | VARCHAR2 (50 Bytes) | |
COUNTOCCURRENCE | NUMBER | |
SYSID | NUMBER | |
SYSNAME | VARCHAR2 (250 Bytes) |
PV_SYS_METRIC_EVENT
This view contains information on events owned by system metrics.Column Name | Data Type | Description |
|---|---|---|
TS | DATE | Timestamp |
EVENTTYPEID | NUMBER | |
EVENTTYPENAME | VARCHAR2 (50 Bytes) | |
EVENTSUBTYPEID | NUMBER | |
EVENTSUBTYPENAME | VARCHAR2 (50 Bytes) | |
EVENTID | NUMBER | |
EVENTTS | DATE | |
INTERVENTTS | DATE | |
RESOLUTIONTS | DATE) | |
EVENTNAME | VARCHAR2 (250 Bytes) | |
EVENTDESC | VARCHAR2 (4000 Bytes) | |
NOTE | VARCHAR2 (4000 Bytes) | |
COLOR | VARCHAR2 (50 Bytes) | |
PERIOD | NUMBER | |
PERIODSINCEDATE | DATE | |
PERIODTODATE | DATE | |
SEVERITY | VARCHAR2 (50 Bytes) | |
STATUS | VARCHAR2 (50 Bytes) | |
SERVICEUNAVAILABILITY | NUMBER | |
PENDINGTIMEMILLIS | NUMBER | |
INTERVENTTIMEMILLIS | NUMBER) | |
RESOLUTIONTIMEMILLIS | NUMBER | |
SOURCECLASS | VARCHAR2 (512 Bytes) | |
SRCEVENTID | VARCHAR2 (50 Bytes) | |
COUNTOCCURRENCE | NUMBER | |
SYSID | NUMBER | |
SYSMETRICID | NUMBER | |
SYSNAME | VARCHAR2 (250 Bytes) | |
SYSDESC | VARCHAR2 (4000 Bytes) | |
SYSTYPEID | NUMBER (22 Bytes) | |
SYSTYPE | VARCHAR2 (50 Bytes) | |
METRIC | VARCHAR2 (50 Bytes) | |
METRICNAME | VARCHAR2 (250 Bytes) | |
SUBMETRICNAME | VARCHAR2 (512 Bytes) |
PV_SYS_CONF_VARIATION
This view describes historical changes in configuration metric instances (CONF). See how CONF metrics are recorded in BMC Helix Capacity Optimization, in the page Capacity Agent metric groups and metrics.This view shows every past value of each configuration metric instance. If you are trying to extract the current values of configuration metric instances, you probably want to use the view PV_SYS_CONF_LAST below. That view contains only the last value of the configuration parameters.
The key column in this view is SYSMETRICID, which is an internal BMC Helix Capacity Optimization-generated unique number assigned to each metric instance.
Column Name | Data Type | Description | Key column |
|---|---|---|---|
SYSMETRICID | NUMBER | System metric ID | PK. FK for SYSMETRICID in PV_SYS_METRIC |
SINCEDATA | DATE | Value validity start day | PK |
TODATE | DATE | Value validity end day | |
VALUE | VARCHAR2 | Metric value |
To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.
E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_NUM'
Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.
Apart from the changes in system configuration metrics values, if you want to check the historical changes in workload configuration metrics you can use PV_BDRV_CONF_VARIATION view.
PV_SYS_CONF_LAST
This view reports only the last value of system configuration metric instances.See how CONF metrics are recorded in BMC Helix Capacity Optimization, in the page Capacity Agent metric groups and metrics.
If you are looking for past values, use the view PV_SYS_CONF_VARIATION above.
The key column is SYSMETRICID, which is an internal BMC Helix Capacity Optimization-generated unique number assigned to each metric instance.
Column Name | Data Type | Description | Key column |
|---|---|---|---|
SYSMETRICID | NUMBER | System metric ID | PK |
SINCEDATE | DATE | Value validity start day | |
TODATE | DATE | Value validity end day | |
VALUE | VARCHAR2 | Metric value | |
INSERTTS | DATE | Timestamp of insertion of this row. This is when the metric instance was created, or when the metric value was last changed. | |
UPDATETS | DATE | Timestamp of last update on this row. This is when the metric instance value shown in this row was last loaded by a connector. |
To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.
E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_NUM'
Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.
Apart from the last value of system configuration metric if you want to check the last value of workload configuration metrics you can use PV_BDRV_CONF_LAST view.
PV_SYS_DATA_DETAIL
This view contains system data in its original state. It does not have any default resolution.The key column for this view is SYSMETRICID, which is an internal BMC Helix Capacity Optimization generated unique number assigned to each metric instance.
To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.
E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_MHZ'
Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.
Column Name | Data Type | Description | Key column |
|---|---|---|---|
SYSMETRICID | NUMBER | System metric ID | PK |
TS | DATE | Timestamp | PK |
DCLASSID | NUMBER | The Day class ID refers to the day for which statistics are calculated. | |
HCLASSID | NUMBER | If hour classes are defined, the Hour class ID refers to individual classes for which statistics are calculated. For example, you can categorize a day into three classes (in hours) that signify work shifts. | |
DURATION | NUMBER | Interval duration [seconds] | |
AVGVALUE | NUMBER | Average samples value in the interval. | |
MINVALUE | NUMBER | Minimum sample value in the interval. | |
MAXVALUE | NUMBER | Maximum sample value in the interval. | |
SUMVALUE | NUMBER | Sum of samples values in the interval. | |
SUMQUADVALUE | NUMBER | Sum of samples square values in the interval. | |
COUNTGOOD | NUMBER | Number of samples in the interval with good value. | |
COUNTWARN | NUMBER | Number of samples in the interval with warning value. | |
COUNTPOOR | NUMBER | Number of samples in the interval with poor value. | |
COUNTERROR | NUMBER | Number of erroneous samples in the interval. | |
COUNTVALUE | NUMBER | Number of samples in the interval. | |
WEIGHT | NUMBER | Weight related to resource value. When no value is specified, the default value is 1. | |
WAVGVALUE | NUMBER | Weighted average value. |
The recommended aggregation to preserve data semantics in this view is explained in the following code:
SUM(duration) AS duration,
DECODE(SUM(duration),0,0,SUM(avgvalue*duration)/SUM(duration)) AS avgvalue,
MIN(minvalue) AS minvalue,
MAX(maxvalue) AS maxvalue,
SUM(sumvalue) AS sumvalue,
SUM(sumquadvalue) AS sumquadvalue,
SUM(countgood) AS countgood,
SUM(countwarn) AS countwarn,
SUM(countpoor) AS countpoor,
SUM(counterror) AS counterror,
SUM(countvalue) AS countvalue,
SUM(weight) AS weight,
DECODE(SUM(weight),0,0,SUM(wavgvalue*weight)/SUM(weight)) AS wavgvalue,
In order to compute the variance of data samples, you can apply the following statement to the result of a time aggregation query:
decode(countvalue,1,0,
(sumquadvalue/(countvalue-1)-power(avgvalue,2)*countvalue/(countvalue-1))
PV_SYS_DATA_DH
This view contains system data at hourly resolution, So for given date there will be 24 rows for given sysmetricid. This view has the structure of, and uses the same aggregation recommended for and present in the PV_SYS_DATA_DETAIL view.
The key columns for this view are SYSMETRICID,TS,DCLASSID,PCLASSID.
Here SYSMETRICID is an internal BMC Helix Capacity Optimization generated unique number assigned to each metric instance.
TS is the timestamp of the of the value available for metric instance.
DCLASSID: This column is calculated by the DWH starting from the sample ts and using the calendar definition. This can be used for filtering purposes i.e. to consider/exclude set of day classes.
PCLASSID: A user can manually mark some point in an analysis as regular outlier or relation outlier.
when a point is marked as outlier its contribution is separated from non oultier samples (pclassid=0) like the MDCH case
So also at hour level (when the outlier is marked at detail level and the original resolution is less than 1h) you can have two samples for the same hour
ts | plclass | value | duration |
|---|---|---|---|
00:00 | normal (pclassid=0) | 10 | 3300 |
00:00 | outlier | 10000000 | 300 |
To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.
E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_MHZ'
Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.
PV_SYS_DATA_D
This view contains system data at daily resolution. This view has the same structure of, and uses the same aggregation as present in the PV_SYS_DATA_DETAIL view.
The key columns for this view are SYSMETRICID,TS,DCLASSID,PCLASSID.
Here SYSMETRICID is an internal BMC Helix Capacity Optimization generated unique number assigned to each metric instance.
TS is the timestamp of the of the value available for metric instance.
DCLASSID: This column is calculated by the DWH starting from the sample ts and using the calendar definition. This can be used for filtering purposes i.e. to consider/exclude set of day classes.
PCLASSID: A user can manually mark some point in an analysis as regular outlier or relation outlier.
when a point is marked as outlier its contribution is separated from non oultier samples (pclassid=0) like the MDCH case
So also at hour level (when the outlier is marked at detail level and the original resolution is less than 1h) you can have two samples for the same hour
ts | plclass | value | duration |
|---|---|---|---|
00:00 | normal (pclassid=0) | 10 | 3300 |
00:00 | outlier | 10000000 | 300 |
To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.
E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_MHZ'
Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.
PV_SYS_DATA_DAY
Column Name | Data Type |
|---|---|
| SYSMETRICID | NUMBER |
| TS | DATE |
| TZOFFSET | NUMBER |
| PCLASSID | NUMBER |
| DCLASSID | NUMBER |
| HCLASSID | NUMBER |
| DURATION | NUMBER |
| AVGVALUE | NUMBER |
| MINVALUE | NUMBER |
| MAXVALUE | NUMBER |
| SUMVALUE | NUMBER |
| SUMQUADVALUE | NUMBER |
| CUMSUMVALUE | NUMBER |
| WEIGHT | NUMBER |
| WAVGVALUE | NUMBER |
| COUNTGOOD | NUMBER |
| COUNTWARN | NUMBER |
| COUNTPOOR | NUMBER |
| COUNTERROR | NUMBER |
| COUNTVALUE | NUMBER |
PV_SYS_DATA_MDCH
This contains system data at monthly resolution. This view has the structure of, and uses the same aggregation recommended for and present in the PV_SYS_DATA_DETAIL view.
The key columns for this view are SYSMETRICID,TS,DCLASSID,PCLASSID.
Here SYSMETRICID is an internal BMC Helix Capacity Optimization generated unique number assigned to each metric instance.
TS is the timestamp of the of the value available for metric instance.
DCLASSID: This column is calculated by the DWH starting from the sample ts and using the calendar definition. This can be used for filtering purposes i.e. to consider/exclude set of day classes.
PCLASSID: A user can manually mark some point in an analysis as regular outlier or relation outlier.
when a point is marked as outlier its contribution is separated from non outlier samples (pclassid=0) like the MDCH case
So also at hour level (when the outlier is marked at detail level and the original resolution is less than 1h) you can have two samples for the same hour
ts | plclass | value | duration |
|---|---|---|---|
00:00 | normal (pclassid=0) | 10 | 3300 |
00:00 | outlier | 10000000 | 300 |
To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.
For example, select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_MHZ'
Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.
PV_SYS_DATA_RAW
This view contains system data at its original resolution. No time aggregation is performed on this. This view has the structure of, and uses the same aggregation recommended for and present in the PV_SYS_DATA_DETAIL view.
The key columns for this view are SYSMETRICID and TS.
Here SYSMETRICID is an internal BMC Helix Capacity Optimization generated unique number assigned to each metric instance.
TS is the timestamp of the of the value available for metric instance.
To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.
E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_MHZ'
Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.
PV_SYS_DATA_CUST_STAT
Column Name | Data Type | Description |
|---|---|---|
SYSOBJID | NUMBER | |
STATID | NUMBER | |
TS | DATE | Timestamp |
VALUE | NUMBER | |
COUNTSAMPLE | NUMBER | |
STATPRODID | NUMBER) | |
STRINGVALUE | VARCHAR2 (250 Bytes) | |
NAME | VARCHAR2 (50 Bytes) | |
DESCRIPTION | VARCHAR2 (250 Bytes) | |
VALTYPEID | NUMBER | See PV_CAT_VAL_TYPE. |
OWNERSHIP | NUMBER |
PV_SYS_DATA_DETAIL_EXOU
Column Name | Data Type |
|---|---|
| SYSMETRICID | NUMBER |
| TS | DATE |
| TZOFFSET | NUMBER |
| PCLASSID | NUMBER |
| DCLASSID | NUMBER |
| HCLASSID | NUMBER |
| DURATION | NUMBER |
| AVGVALUE | NUMBER |
| MINVALUE | NUMBER |
| MAXVALUE | NUMBER |
| SUMVALUE | NUMBER |
| SUMQUADVALUE | NUMBER |
| CUMSUMVALUE | NUMBER |
| WEIGHT | NUMBER |
| WAVGVALUE | NUMBER |
| COUNTGOOD | NUMBER |
| COUNTWARN | NUMBER |
| COUNTPOOR | NUMBER |
| COUNTERROR | NUMBER |
| COUNTVALUE | NUMBER |
PV_SYS_DATA_DH_EXOU
Column Name | Data Type |
|---|---|
| SYSMETRICID | NUMBER |
| TS | DATE |
| TZOFFSET | NUMBER |
| PCLASSID | NUMBER |
| DCLASSID | NUMBER |
| HCLASSID | NUMBER |
| DURATION | NUMBER |
| AVGVALUE | NUMBER |
| MINVALUE | NUMBER |
| MAXVALUE | NUMBER |
| SUMVALUE | NUMBER |
| SUMQUADVALUE | NUMBER |
| CUMSUMVALUE | NUMBER |
| WEIGHT | NUMBER |
| WAVGVALUE | NUMBER |
| COUNTGOOD | NUMBER |
| COUNTWARN | NUMBER |
| COUNTPOOR | NUMBER |
| COUNTERROR | NUMBER |
| COUNTVALUE | NUMBER |
PV_SYS_DATA_D_EXOU
Column Name | Data Type |
|---|---|
| SYSMETRICID | NUMBER |
| TS | DATE |
| TZOFFSET | NUMBER |
| PCLASSID | NUMBER |
| DCLASSID | NUMBER |
| HCLASSID | NUMBER |
| DURATION | NUMBER |
| AVGVALUE | NUMBER |
| MINVALUE | NUMBER |
| MAXVALUE | NUMBER |
| SUMVALUE | NUMBER |
| SUMQUADVALUE | NUMBER |
| CUMSUMVALUE | NUMBER |
| WEIGHT | NUMBER |
| WAVGVALUE | NUMBER |
| COUNTGOOD | NUMBER |
| COUNTWARN | NUMBER |
| COUNTPOOR | NUMBER |
| COUNTERROR | NUMBER |
| COUNTVALUE | NUMBER |
PV_SYS_DATA_MDCH_EXOU
Column Name | Data Type |
|---|---|
| SUMVALUE | NUMBER |
| SUMQUADVALUE | NUMBER |
| CUMSUMVALUE | NUMBER |
| WEIGHT | NUMBER |
| WAVGVALUE | NUMBER |
| SLOPE | NUMBER |
| COUNTGOOD | NUMBER |
| COUNTWARN | NUMBER |
| COUNTPOOR | NUMBER |
| COUNTERROR | NUMBER |
| COUNTVALUE | NUMBER |
| SYSMETRICID | NUMBER |
| TS | DATE |
| TZOFFSET | NUMBER |
| PCLASSID | NUMBER |
| DCLASSID | NUMBER |
| HCLASSID | NUMBER |
| DURATION | NUMBER |
| AVGVALUE | NUMBER |
| MINVALUE | NUMBER |
| MAXVALUE | NUMBER |
PV_SYS_DATA_MONTH
Column Name | Data Type |
|---|---|
| COUNTERROR | NUMBER |
| COUNTVALUE | NUMBER |
| SYSMETRICID | NUMBER |
| TS | DATE |
| TZOFFSET | NUMBER |
| PCLASSID | NUMBER |
| DCLASSID | NUMBER |
| HCLASSID | NUMBER |
| DURATION | NUMBER |
| AVGVALUE | NUMBER |
| MINVALUE | NUMBER |
| MAXVALUE | NUMBER |
| SUMVALUE | NUMBER |
| SUMQUADVALUE | NUMBER |
| CUMSUMVALUE | NUMBER |
| WEIGHT | NUMBER |
| WAVGVALUE | NUMBER |
| SLOPE | NUMBER |
| COUNTGOOD | NUMBER |
| COUNTWARN | NUMBER |
| COUNTPOOR | NUMBER |
PV_SYS_DATA_ROLL
Column Name | Data Type |
|---|---|
| SYSMETRICID | NUMBER |
| ROLLPERIOD | NUMBER |
| TS | DATE |
| UPDATETS | DATE |
| DURATION | NUMBER |
| COUNT | NUMBER |
| AVG | NUMBER |
| STDDEV | NUMBER |
| MIN | NUMBER |
| MAX | NUMBER |
| SLOPE | NUMBER |
| INTERCEPT | NUMBER |
| PCTILE50 | NUMBER |
| PCTILE05 | NUMBER |
| PCTILE95 | NUMBER |
| PCTILE10 | NUMBER |
| PCTILE90 | NUMBER |
| PCTILE25 | NUMBER |
| PCTILE75 | NUMBER |
PV_SYS_INDICATOR
Column Name | Data Type | Description |
|---|---|---|
| SYSID | NUMBER | |
| SYSMETRICID | NUMBER | |
| NAME | VARCHAR2(250 CHAR) | |
| DESCRIPTION | VARCHAR2(4000 CHAR) | |
| SYSTYPEID | NUMBER | |
| SYSTYPE | VARCHAR2(50 CHAR) | |
| METRIC | VARCHAR2(50 CHAR) | |
| METRICNAME | VARCHAR2(250 CHAR) | |
| SUBMETRICNAME | VARCHAR2(512 CHAR) | |
| LOCATIONID | NUMBER | |
| LOCATIONNAME | VARCHAR2(250 CHAR) | |
| VALTYPEID | NUMBER | |
| VALTYPE | VARCHAR2(50 CHAR) | See PV_CAT_VAL_TYPE. |
| LASTVALUE | VARCHAR2(4000) |
PV_SYS_IND_DATA
Column Name | Data Type | Description |
|---|---|---|
| SYSID | NUMBER | |
| SYSMETRICID | NUMBER | |
| NAME | VARCHAR2(250 CHAR) | |
| DESCRIPTION | VARCHAR2(4000 CHAR) | |
| SYSTYPEID | NUMBER | |
| SYSTYPE | VARCHAR2(50 CHAR) | |
| METRIC | VARCHAR2(50 CHAR) | |
| METRICNAME | VARCHAR2(250 CHAR) | |
| SUBMETRICNAME | VARCHAR2(512 CHAR) | |
| LOCATIONID | NUMBER | |
| LOCATIONNAME | VARCHAR2(250 CHAR) | |
| VALTYPEID | NUMBER | See PV_CAT_VAL_TYPE. |
| VALTYPE | VARCHAR2(50 CHAR) | |
| LASTVALUE | VARCHAR2(4000) |
PV_SYS_TAG
Column Name | Data Type |
|---|---|
| SYSID | NUMBER |
| NAME | VARCHAR2(250 CHAR) |
| SYSTYPEID | NUMBER |
| SYSTYPE | VARCHAR2(50 CHAR) |
| TAGID | NUMBER |
| TAG | VARCHAR2(4000 CHAR) |
| DESCRIPTION | VARCHAR2(250 CHAR) |
| INSERTTS | DATE |
| UPDATETS | DATE |
| TAGTYPEID | NUMBER |
| TAGTYPENAME | VARCHAR2(50 CHAR) |
| TAGTYPECOLOR | VARCHAR2(50 CHAR) |
Category-related views
PV_CAT_APPL_TYPE
| Column Name | Data Type |
|---|---|
| APPLTYPEID | NUMBER |
| NAME | VARCHAR2(50 CHAR) |
| DESCRIPTION | VARCHAR2(250 CHAR) |
| ENTTYPENM | VARCHAR2(50 CHAR) |
| NAMEEN | VARCHAR2(50 CHAR) |
| PACKAGE | VARCHAR2(250 CHAR) |
| VENDOR | VARCHAR2(250 CHAR) |
PV_CAT_AUDIT_ACTION
| Column Name | Data Type |
|---|---|
| AUDITACTIONID | NUMBER |
| NAME | VARCHAR2(50 CHAR) |
| DESCRIPTION | VARCHAR2(250 CHAR) |
| AUDITGROUPID | NUMBER |
| GROUPNAME | VARCHAR2(50 CHAR) |
PV_CAT_BDRV_TYPE
| Column Name | Data Type |
|---|---|
| BDRVTYPEID | NUMBER |
| NAME | VARCHAR2(50 CHAR) |
| DESCRIPTION | VARCHAR2(250 CHAR) |
| ENTTYPENM | VARCHAR2(50 CHAR) |
| NAMEEN | VARCHAR2(50 CHAR) |
| PACKAGE | VARCHAR2(250 CHAR) |
| VENDOR | VARCHAR2(250 CHAR) |
PV_CAT_EVENT_TYPE
| Column Name | Data Type |
|---|---|
| EVENTTYPEID | NUMBER |
| NAME | VARCHAR2(50 CHAR) |
| DESCRIPTION | VARCHAR2(250 CHAR) |
PV_CAT_PARENTSHIP_TYPE
| Column Name | Data Type |
|---|---|
| PARENTSHIPTYPEID | NUMBER |
| NAME | VARCHAR2(50 CHAR) |
| NODENAME | VARCHAR2(250 CHAR) |
| DIRECTION | NUMBER |
| PACKAGE | VARCHAR2(250 CHAR) |
| VENDOR | VARCHAR2(250 CHAR) |
PV_CAT_RM_RECOMM_TYPE
| Column Name | Data Type |
|---|---|
| RMALERTTYPEID | NUMBER |
| NAME | VARCHAR2(250 CHAR) |
| DESCRIPTION | VARCHAR2(4000 CHAR) |
| PACKAGE | VARCHAR2(250 CHAR) |
| VENDOR | VARCHAR2(250 CHAR) |
PV_CAT_SYS_TYPE
| Column Name | Data Type |
|---|---|
| DESCRIPTION | VARCHAR2(250 CHAR) |
| ENTTYPENM | VARCHAR2(50 CHAR) |
| NAMEEN | VARCHAR2(50 CHAR) |
| PACKAGE | VARCHAR2(250 CHAR) |
| VENDOR | VARCHAR2(250 CHAR) |
| SYSTYPEID | NUMBER |
| NAME | VARCHAR2(50 CHAR) |
PV_CAT_VAL_TYPE
| Column Name | Data Type | Description |
|---|---|---|
| VALTYPEID | NUMBER | Number that indicates the type of value of a metric. For example, an absolute value, a percentage, or a frequency. VALTYPEID=5 is used to identify configuration metrics. |
| NAME | VARCHAR2(50 CHAR) | |
| DESCRIPTION | VARCHAR2(250 CHAR) | |
| DEFAULTPLOTCOL | VARCHAR2(50 CHAR) | Contains the default statistic that is used when a metric is selected with the corresponding VALTYPE in an analysis. |
Business Driver related views
PV_BUSINESS_DRIVER
This view contains information on business drivers.
Column Name | Data Type | Description | Key Column |
|---|---|---|---|
BDRVID | NUMBER | Business driver ID | PK |
NAME | VARCHAR2 (50 Bytes) | Business driver name | |
DESCRIPTION | VARCHAR2 (250 Bytes) | Business driver description | |
BDRVTYPEID | NUMBER | Business driver type ID | |
BDRVTYPE | VARCHAR2 (50 Bytes) | Type of the business driver (Generic, ...) |
PV_BDRV_METRIC
This view contains information on business driver metrics.
Column Name | Data Type | Description | Key Column |
|---|---|---|---|
BDRVID | NUMBER | Business driver ID | AK1. FK BDRVID in PV_BUSINESS_DRIVER |
BDRVMETRICID | NUMBER | Business driver metric ID | PK |
NAME | VARCHAR2 (50 Bytes) | Business driver name | |
DESCRIPTION | VARCHAR2 (250 Bytes) | Business driver metric description | |
BDRVTYPEID | NUMBER | Business driver type ID | |
BDRVTYPE | VARCHAR2 (50 Bytes) | Type of the business driver (Generic, ...) | |
METRIC | VARCHAR2 (50 Bytes) | Metric | |
METRICNAME | VARCHAR2 (50 Bytes) | Metric full name | |
SUBMETRICNAME | VARCHAR2 (512 Bytes) | Metric sub element name | AK1 |
LOCATIONID | NUMBER | Location ID | |
LOCATIONNAME | VARCHAR2 (50 Bytes) | Location name | |
VALTYPEID | NUMBER | Value type ID | See PV_CAT_VAL_TYPE. |
VALTYPE | VARCHAR2 (50 Bytes) | Value type (count, rate, ...) |
PV_BDRV_CONF_VARIATION
This view reports variations of business driver configuration parameters.
Column Name | Data Type | Description | Key Column |
|---|---|---|---|
BDRVMETRICID | NUMBER | Business driver metric ID | PK. FK for BDRVMETRICID in PV_BDRV_METRIC |
SINCEDATA | DATE | Value validity start day | PK |
TODATE | DATE | Value validity end day | |
VALUE | VARCHAR2 (250 Bytes) | Metric value |
PV_BDRV_CONF_LAST
This view reports only the last value of business driver configuration parameters.
Column Name | Data Type | Description | Key Column |
|---|---|---|---|
BDRVMETRICID | NUMBER | Business driver metric ID | PK |
SINCEDATE | DATE | Value validity start day | |
TODATE | DATE | Value validity end day | |
VALUE | VARCHAR2 (4000 Bytes) | Metric value | |
INSERTTS | DATE | Timestamp of insertion of this row | |
UPDATETS | DATE | Timestamp of last update on this row |
PV_BDRV_DATA_DETAIL
This view contains system data at its original resolution.Column Name | Data Type | Description | Key Column |
|---|---|---|---|
BDRVMETRICID | NUMBER | Business driver metric ID | PK |
TS | DATE | Timestamp | PK |
DCLASSID | NUMBER | Day class ID | |
HCLASSID | NUMBER | Hour class ID | |
DURATION | NUMBER | Interval duration [seconds] | |
AVGVALUE | NUMBER | Average samples value in the interval | |
MINVALUE | NUMBER | Maximum sample value in the interval | |
MAXVALUE | NUMBER | Minimum sample value in the interval | |
SUMVALUE | NUMBER | Sum of samples values in the interval | |
SUMQUADVALUE | NUMBER | Sum of samples square values in the interval | |
COUNTGOOD | NUMBER | Number of samples in the interval with good value | |
COUNTWARN | NUMBER | Number of samples in the interval with warning value | |
COUNTPOOR | NUMBER | Number of samples in the interval with poor value | |
COUNTERROR | NUMBER | Number of erroneous samples in the interval | |
COUNTVALUE | NUMBER | Number of samples in the interval | |
WEIGHT | NUMBER | Weight related to resource value | |
WAVGVALUE | NUMBER | Weighted average value |
The recommended aggregation to preserve data semantics is:
SUM(duration) AS duration,
DECODE(SUM(duration),0,0,SUM(avgvalue*duration)/SUM(duration)) AS avgvalue,
MIN(minvalue) AS minvalue,
MAX(maxvalue) AS maxvalue,
SUM(sumvalue) AS sumvalue,
SUM(sumquadvalue) AS sumquadvalue,
SUM(countgood) AS countgood,
SUM(countwarn) AS countwarn,
SUM(countpoor) AS countpoor,
SUM(counterror) AS counterror,
SUM(countvalue) AS countvalue,
SUM(weight) AS weight,
DECODE(SUM(weight),0,0,SUM(wavgvalue*weight)/SUM(weight)) AS wavgvalue,
In order to compute the variance of data samples, you can apply the following statement to the result of a time aggregation query:
decode(countvalue,1,0,(sumquadvalue/(countvalue-1)-power(avgvalue,2)*countvalue/(countvalue-1))PV_BDRV_DATA_DH
This view contains system data at hourly resolution. This view has the structure of, and uses the same aggregation recommended for and present in the PV_BDRV_DATA_DETAIL view.
PV_BDRV_DATA_D
This view contains system data at daily resolution. This view has the structure of, and uses the same aggregation recommended for and present in the PV_BDRV_DATA_DETAIL view.
PV_BDRV_DATA_MDCH
This view contains system data at monthly resolution. This view has the structure of, and uses the same aggregation recommended for and present in the PV_BDRV_DATA_DETAIL view.
PV_BDRV_DATA_MDCH_EXOU
Column Name | Data Type |
|---|---|
| BDRVMETRICID | NUMBER |
| TS | DATE |
| TZOFFSET | NUMBER |
| PCLASSID | NUMBER |
| DCLASSID | NUMBER |
| HCLASSID | NUMBER |
| DURATION | NUMBER |
| AVGVALUE | NUMBER |
| MINVALUE | NUMBER |
| MAXVALUE | NUMBER |
| SUMVALUE | NUMBER |
| SUMQUADVALUE | NUMBER |
| CUMSUMVALUE | NUMBER |
| WEIGHT | NUMBER |
| WAVGVALUE | NUMBER |
| SLOPE | NUMBER |
| COUNTGOOD | NUMBER |
| COUNTWARN | NUMBER |
| COUNTPOOR | NUMBER |
| COUNTERROR | NUMBER |
| COUNTVALUE | NUMBER |
PV_BDRV_DATA_CUST_STAT
Column Name | Data Type | Description |
|---|---|---|
NAME | VARCHAR2 (50 Bytes) | |
DESCRIPTION | VARCHAR2 (250 Bytes) | |
VALTYPEID | NUMBER | See PV_CAT_VAL_TYPE. |
OWNERSHIP | NUMBER | |
BDRVOBJID | NUMBER | |
STATID | NUMBER | |
TS | DATE | Timestamp |
VALUE | NUMBER) | |
COUNTSAMPLE | NUMBER | |
STATPRODID | NUMBER | |
STRINGVALUE | VARCHAR2 (250 Bytes) |
PV_BDRV_DATA_DETAIL_EXOU
| Column Name | Data Type |
|---|---|
| BDRVMETRICID | NUMBER |
| TS | DATE |
| TZOFFSET | NUMBER |
| PCLASSID | NUMBER |
| DCLASSID | NUMBER |
| HCLASSID | NUMBER |
| DURATION | NUMBER |
| AVGVALUE | NUMBER |
| MINVALUE | NUMBER |
| MAXVALUE | NUMBER |
| SUMVALUE | NUMBER |
| SUMQUADVALUE | NUMBER |
| CUMSUMVALUE | NUMBER |
| WEIGHT | NUMBER |
| WAVGVALUE | NUMBER |
| COUNTGOOD | NUMBER |
| COUNTWARN | NUMBER |
| COUNTPOOR | NUMBER |
| COUNTERROR | NUMBER |
| COUNTVALUE | NUMBER |
PV_BDRV_DATA_DH_EXOU
| Column Name | Data Type |
|---|---|
| BDRVMETRICID | NUMBER |
| TS | DATE |
| TZOFFSET | NUMBER |
| PCLASSID | NUMBER |
| DCLASSID | NUMBER |
| HCLASSID | NUMBER |
| DURATION | NUMBER |
| AVGVALUE | NUMBER |
| MINVALUE | NUMBER |
| MAXVALUE | NUMBER |
| SUMVALUE | NUMBER |
| SUMQUADVALUE | NUMBER |
| CUMSUMVALUE | NUMBER |
| WEIGHT | NUMBER |
| WAVGVALUE | NUMBER |
| COUNTGOOD | NUMBER |
| COUNTWARN | NUMBER |
| COUNTPOOR | NUMBER |
| COUNTERROR | NUMBER |
| COUNTVALUE | NUMBER |
PV_BDRV_DATA_D_EXOU
| Column Name | Data Type |
|---|---|
| BDRVMETRICID | NUMBER |
| TS | DATE |
| TZOFFSET | NUMBER |
| PCLASSID | NUMBER |
| DCLASSID | NUMBER |
| HCLASSID | NUMBER |
| DURATION | NUMBER |
| AVGVALUE | NUMBER |
| MINVALUE | NUMBER |
| MAXVALUE | NUMBER |
| SUMVALUE | NUMBER |
| SUMQUADVALUE | NUMBER |
| CUMSUMVALUE | NUMBER |
| WEIGHT | NUMBER |
| WAVGVALUE | NUMBER |
| COUNTGOOD | NUMBER |
| COUNTWARN | NUMBER |
| COUNTPOOR | NUMBER |
| COUNTERROR | NUMBER |
| COUNTVALUE | NUMBER |
PV_BDRV_DATA_MDCH_EXOU
| Column Name | Data Type |
|---|---|
| BDRVMETRICID | NUMBER |
| TS | DATE |
| TZOFFSET | NUMBER |
| PCLASSID | NUMBER |
| DCLASSID | NUMBER |
| HCLASSID | NUMBER |
| DURATION | NUMBER |
| AVGVALUE | NUMBER |
| MINVALUE | NUMBER |
| MAXVALUE | NUMBER |
| SUMVALUE | NUMBER |
| SUMQUADVALUE | NUMBER |
| CUMSUMVALUE | NUMBER |
| WEIGHT | NUMBER |
| WAVGVALUE | NUMBER |
| COUNTGOOD | NUMBER |
| COUNTWARN | NUMBER |
| COUNTPOOR | NUMBER |
| COUNTERROR | NUMBER |
| COUNTVALUE | NUMBER |
PV_BDRV_DATA_RAW
| Column Name | Data Type |
|---|---|
| BDRVMETRICID | NUMBER |
| TS | TIMESTAMP(6) |
| TZOFFSET | NUMBER |
| DURATION | NUMBER |
| AVGVALUE | NUMBER |
| MINVALUE | NUMBER |
| MAXVALUE | NUMBER |
| SUMVALUE | NUMBER |
| SUMQUADVALUE | NUMBER |
| CUMSUMVALUE | NUMBER |
| WEIGHT | NUMBER |
| WAVGVALUE | NUMBER |
| COUNTVALUE | NUMBER |
| COUNTGOOD | NUMBER |
| COUNTWARN | NUMBER |
| COUNTPOOR | NUMBER |
| COUNTERROR | NUMBER |
| COUNTPOOR | NUMBER |
| COUNTERROR | NUMBER |
PV_BDRV_DATA_ROLL
| Column Name | Data Type |
|---|---|
| BDRVMETRICID | NUMBER |
| ROLLPERIOD | NUMBER |
| TS | DATE |
| UPDATETS | DATE |
| DURATION | NUMBER |
| COUNT | NUMBER |
| AVG | NUMBER |
| STDDEV | NUMBER |
| MIN | NUMBER |
| MAX | NUMBER |
| SLOPE | NUMBER |
| INTERCEPT | NUMBER |
| PCTILE50 | NUMBER |
| PCTILE05 | NUMBER |
| PCTILE95 | NUMBER |
| PCTILE10 | NUMBER |
| PCTILE90 | NUMBER |
| PCTILE25 | NUMBER |
| PCTILE75 | NUMBER |
PV_BDRV_EVENT
| Column Name | Data Type |
|---|---|
| TS | DATE |
| EVENTTYPEID | NUMBER |
| EVENTTYPENAME | VARCHAR2(50 CHAR) |
| EVENTSUBTYPEID | NUMBER |
| EVENTSUBTYPENAME | VARCHAR2(50 CHAR) |
| EVENTID | NUMBER |
| EVENTTS | DATE |
| INTERVENTTS | DATE |
| RESOLUTIONTS | DATE |
| EVENTNAME | VARCHAR2(250 CHAR) |
| EVENTDESC | VARCHAR2(4000 CHAR) |
| NOTE | VARCHAR2(4000 CHAR) |
| COLOR | VARCHAR2(50 CHAR) |
| PERIOD | NUMBER |
| PERIODSINCEDATE | DATE |
| PERIODTODATE | DATE |
| SEVERITY | VARCHAR2(50 CHAR) |
| STATUS | VARCHAR2(50 CHAR) |
| SERVICEUNAVAILABILITY | NUMBER |
| PENDINGTIMEMILLIS | NUMBER |
| INTERVENTTIMEMILLIS | NUMBER |
| RESOLUTIONTIMEMILLIS | NUMBER |
| SOURCECLASS | VARCHAR2(512 CHAR) |
| SRCEVENTID | VARCHAR2(50 CHAR) |
| COUNTOCCURRENCE | NUMBER |
| BDRVID | NUMBER |
| BDRVNAME | VARCHAR2(250 CHAR) |
| BDRVDESC | VARCHAR2(4000 CHAR) |
| BDRVTYPEID | NUMBER |
| BDRVTYPE | VARCHAR2(50 CHAR) |
PV_BDRV_METRIC_EVENT
| Column Name | Data Type | Description |
|---|---|---|
| TS | DATE | |
| EVENTTYPEID | NUMBER | |
| EVENTTYPENAME | VARCHAR2(50 CHAR) | |
| EVENTSUBTYPEID | NUMBER | |
| EVENTSUBTYPENAME | VARCHAR2(50 CHAR) | |
| EVENTID | NUMBER | |
| EVENTTS | DATE | |
| INTERVENTTS | DATE | |
| RESOLUTIONTS | DATE | |
| EVENTNAME | VARCHAR2(250 CHAR) | |
| EVENTDESC | VARCHAR2(4000 CHAR) | |
| NOTE | VARCHAR2(4000 CHAR) | |
| COLOR | VARCHAR2(50 CHAR) | |
| PERIOD | NUMBER | |
| PERIODSINCEDATE | DATE | |
| PERIODTODATE | DATE | |
| SEVERITY | VARCHAR2(50 CHAR) | |
| STATUS | VARCHAR2(50 CHAR) | |
| SERVICEUNAVAILABILITY | NUMBER | |
| PENDINGTIMEMILLIS | NUMBER | |
| INTERVENTTIMEMILLIS | NUMBER | |
| RESOLUTIONTIMEMILLIS | NUMBER | |
| SOURCECLASS | VARCHAR2(512 CHAR) | |
| SRCEVENTID | VARCHAR2(50 CHAR) | |
| COUNTOCCURRENCE | NUMBER | |
| BDRVID | NUMBER | |
| BDRVMETRICID | NUMBER | |
| BDRVNAME | VARCHAR2(250 CHAR) | |
| BDRVDESC | VARCHAR2(4000 CHAR) | |
| BDRVTYPEID | NUMBER | |
| BDRVTYPE | VARCHAR2(50 CHAR) | |
| METRIC | VARCHAR2(50 CHAR) | |
| METRICNAME | VARCHAR2(250 CHAR) | |
| SUBMETRICNAME | VARCHAR2(512 CHAR) | |
| LOCATIONID | NUMBER | |
| LOCATIONNAME | VARCHAR2(250 CHAR) | |
| VALTYPEID | NUMBER | See PV_CAT_VAL_TYPE. |
| VALTYPE | VARCHAR2(50 CHAR) |
Class ID views
PV_H_CLASS
This view provides names and descriptions for hour class IDs.
Column Name | Data Type | Description |
|---|---|---|
HCLASSID | NUMBER | Hour class ID |
NAME | VARCHAR2 (50 Bytes) | Hour class NAME |
DESCRIPTION | VARCHAR2 (250 Bytes) | Hour class description |
PV_D_CLASS
This view provides names and descriptions for day class IDs.
Column Name | Data Type | Description |
|---|---|---|
DCLASSID | NUMBER | Day class ID |
NAME | VARCHAR2 (50 Bytes) | Day class NAME |
DESCRIPTION | VARCHAR2 (250 Bytes) | Day class description |
Chargeback related views
PV_CB_COST_OBJECT
This view contains information on a cost object.
Column Name | Data Type | Description |
|---|---|---|
COSTOBJID | NUMBER | Cost object ID |
NAME | VARCHAR2 (50 Bytes) | Cost object name |
DESCRIPTION | VARCHAR2 (250 Bytes) | Cost object description |
COSTOBJTYPEID | NUMBER | Cost object type ID |
COSTOBJTYPE | VARCHAR2 (50 Bytes) | Type of the cost object |
COSTOBJKEY | NUMBER | Cost object key |
PV_CB_COST_OBJECT_METADATA
Column Name | Data Type |
|---|---|
| COSTOBJID | NUMBER |
| COSTOBJKEY | VARCHAR2(250 CHAR) |
| COSTOBJSUBKEY | VARCHAR2(250 CHAR) |
| NAME | VARCHAR2(250 CHAR) |
| VALUE | VARCHAR2(4000 CHAR) |
PV_CB_COST_OBJECT_SUBKEY
This view contains information on subkeys of a basic cost object.
Column Name | Data Type | Description | References |
|---|---|---|---|
COSTOBJID | NUMBER | Cost object ID | PV_CB_COST_OBJECT.COSTOBJID |
COSTOBJKEY | VARCHAR2 (50 Bytes) | Cost object key | PV_CB_COST_OBJECT.COSTOBJKEY |
COSTOBJSUBKEY | VARCHAR2 (50 Bytes) | Cost object subkey | |
PROPNAME | VARCHAR2 (250 Bytes) | Name of the property (mode, consunit, label) | |
PROPVALUE | VARCHAR2 (250 Bytes) | Value of the property |
PV_CB_CO_ALLOC
This view contains information on an allocation between a composite cost object and a cost object.
Column Name | Data Type | Description | References |
|---|---|---|---|
COSTOBJID | NUMBER | Cost object ID | PV_CB_COST_OBJECT.COSTOBJID |
COSTOBJNAME | VARCHAR2 (50 Bytes) | Cost object name | |
COSTOBJKEY | VARCHAR2 (50 Bytes) | Cost object key | PV_CB_COST_OBJECT.COSTOBJKEY |
COSTOBJIDALLOC | NUMBER | Cost object ID allocated | PV_CB_COST_OBJECT.COSTOBJID |
COSTOBJNAMEALLOC | VARCHAR2 (50 Bytes) | Cost object name allocated | |
COSTOBJKEYALLOC | NUMBER | Cost object key allocated | PV_CB_COST_OBJECT.COSTOBJKEY |
ALLOCATION | NUMBER | Percentage of allocation | |
SINCEDATE | DATE | Allocation validity start day | |
TODATE | DATE | Allocation validity end day |
PV_CB_TARGET
This view contains information on a target
Column Name | Data Type | Description |
|---|---|---|
TARGETID | NUMBER | Target ID |
NAME | VARCHAR2 (50 Bytes) | Target name |
DESCRIPTION | VARCHAR2 (250 Bytes) | Target description |
PV_CB_MODEL
This view contains information on a chargeback model
Column Name | Data Type | Description |
|---|---|---|
MODELID | NUMBER | Model ID |
NAME | VARCHAR2 (50 Bytes) | Model name |
DESCRIPTION | VARCHAR2 (250 Bytes) | Model description |
TARGETIDPARENT | NUMBER | Target root ID |
CURRENCY | VARCHAR2 (50 Bytes) | Currency |
PV_CB_MODEL_TARGET
Column Name | Data Type |
|---|---|
| ACBMDELID | NUMBER |
| ACBTARGETID | NUMBER |
PV_CB_TARGET_PARENTSHIP
This view contains information on a target hierarchy.
Column Name | Data Type | Description | References |
|---|---|---|---|
MODELID | NUMBER | Model ID | PV_CB_MODEL.MODELID |
TARGETIDPARENT | NUMBER | Target parent ID | PV_CB_TARGET.TARGETID |
TARGETIDCHILD | NUMBER | Target child ID | PV_CB_TARGET.TARGETID |
PV_CB_TARGET_METADATA
Column Name | Data Type |
|---|---|
| TARGETID | NUMBER |
| NAME | VARCHAR2(250 CHAR) |
| VALUE | VARCHAR2(4000 CHAR) |
PV_CB_ALLOCATION
This view contains information on an allocation between a target and a cost object.
Column Name | Data Type | Description | References |
|---|---|---|---|
MODELID | NUMBER | Model ID | PV_CB_MODEL.MODELID |
TARGETID | NUMBER | Target ID | PV_CB_TARGET.TARGETID |
TARGETNAME | VARCHAR2 (50 Bytes) | Target name | |
COSTOBJID | NUMBER | Cost object ID | PV_CB_COST_OBJECT.COSTOBJID |
COSTOBJNAME | VARCHAR2 (50 Bytes) | Cost object name | |
COSTOBJKEY | VARCHAR2 (50 Bytes) | Cost object key | PV_CB_COST_OBJECT.COSTOBJKEY |
ALLOCATION | NUMBER | Percentage of allocation | |
SINCEDATE | DATE | Allocation validity start day | |
TODATE | DATE | Allocation validity end day |
PV_CB_ALLOCATION_METADATA
Column Name | Data Type |
|---|---|
| ALLOCID | NUMBER |
| NAME | VARCHAR2(250 CHAR) |
| VALUE | VARCHAR2(4000 CHAR) |
PV_CB_TARGET_METRIC
This view contains information on target metrics.Column Name | Data Type | Description | References |
|---|---|---|---|
TARGETID | NUMBER | Target ID | PV_CB_TARGET.TARGETID |
TARGETNAME | VARCHAR2 (50 Bytes) | Target name | |
TARGETMETRICID | NUMBER | Target metric ID | |
METRIC | VARCHAR2 (50 Bytes) | Metric | |
METRICNAME | VARCHAR2 (50 Bytes) | Metric full name | |
COCOSTOBJKEY4 | VARCHAR2 (50 Bytes) | Composite cost object key level 4 | PV_CB_COST_OBJECT.COSTOBJKEY |
COCOSTOBJKEY3 | VARCHAR2 (50 Bytes) | Composite cost object key level 3 | PV_CB_COST_OBJECT.COSTOBJKEY |
COCOSTOBJKEY2 | VARCHAR2 (50 Bytes) | Composite cost object key level 2 | PV_CB_COST_OBJECT.COSTOBJKEY |
COCOSTOBJKEY1 | VARCHAR2 (50 Bytes) | Composite cost object key level 1 | PV_CB_COST_OBJECT.COSTOBJKEY |
COSTOBJKEY | VARCHAR2 (50 Bytes) | Basic Cost object key | PV_CB_COST_OBJECT.COSTOBJKEY |
COSTOBJSUBKEY | VARCHAR2 (50 Bytes) | Cost object subkey | PV_CB_COST_OBJECT_SUBKEY.COSTOBJSUBKEY |
METADATA | VARCHAR2 (50 Bytes) | Metadata |
Note
There can be a maximum of 4 nested composite cost object levels. Levels are labeled as shown in the following figure:
Cost object nesting 
PV_CB_TARGET_DATA_DAY
This view contains target data.Column Name | Data Type | Description | References |
|---|---|---|---|
TARGETMETRICID | NUMBER | Target metric | ID PV_CB_TARGET.TARGETID |
TS | DATE | Timestamp | |
DURATION | NUMBER | Duration of the period in which samples were collected | |
VALUE | NUMBER | Sample value |
PV_CB_COST_RATE
This view contains information on a cost rate.Column Name | Data Type | Description | References |
|---|---|---|---|
MODELID | NUMBER | Model ID | PV_CB_MODEL.MODELID |
COSTOBJID | NUMBER | Cost object | ID PV_CB_COST_OBJECT.COSTOBJID |
COSTOBJNAME | VARCHAR2 (50 Bytes) | Cost object name | |
COSTOBJKEY | VARCHAR2 (50 Bytes) | Cost object key | PV_CB_COST_OBJECT.COSTOBJKEY |
COSTOBJSUBKEY | VARCHAR2 (50 Bytes) | Cost object subkey | PV_CB_COST_OBJECT_SUBKEY.COSTOBJSUBKEY |
METADATA | VARCHAR2 (250 Bytes) | Metadata value | |
COSTRATENAME | VARCHAR2 (50 Bytes) | Cost rate name | |
COSTRATE | NUMBER | Cost rate value | |
CONSUNIT | VARCHAR2 (50 Bytes) | Consumption unit | |
COSTUNIT | VARCHAR2 (50 Bytes) | Cost unit | |
SINCEDATE | DATE | Cost rate validity start day | |
TODATE | DATE | Cost rate validity end day |
PV_CB_COST_RATE_METADATA
Column Name | Data Type |
|---|---|
| COSTRATEID | NUMBER |
| NAME | VARCHAR2(250 CHAR) |
| VALUE | VARCHAR2(4000 CHAR) |
Other
PV_ENT_PARENTSHIP_CURRENT
This view contains information on relationship between systems, business drivers and domains (hierarchy).
Column Name | Data Type | Description | Key column |
|---|---|---|---|
STRUCTUREIDPARENT | VARCHAR2 (6 Bytes) | Structure of father node | PK. “FK” indicates whether parent is a SYS, BDRV, or APP |
IDPARENT | NUMBER | ID of father node | PK. FK SYSID in PV_SYSTEM, or FK APPID in PV_APPLICATION, or FK BDRVID in PV_BDRV |
STRUCTUREIDCHILD | VARCHAR2 (6 Bytes) | Structure of child node | PK. “FK” indicates whether child is a SYS, BDRV, or APP |
IDCHILD | NUMBER | ID of child node | PK. FK SYSID in PV_SYSTEM, or FK APPID in PV_APPLICATION, or FK BDRVID in PV_BDRV |
SINCEDATE | DATE | Value validity start day | |
TODATE | DATE | Value validity end day | |
PARENTSHIPTYPEID | NUMBER | Parentship type ID | |
PARENTSHIPTYPE | VARCHAR2 (50 Bytes) | Parentship type name |
PV_ENT_PARENTSHIP_HIST
This view contains historical information on relationship between systems, business drivers and domains (hierarchy).
Column Name | Data Type | Description | Key column |
|---|---|---|---|
STRUCTUREIDPARENT | VARCHAR2 (6 Bytes) | Structure of father node | PK. “FK” indicates whether parent is a SYS, BDRV, or APP |
IDPARENT | NUMBER | ID of father node | PK. FK SYSID in PV_SYSTEM, or FK APPID in PV_APPLICATION, or FK BDRVID in PV_BDRV |
STRUCTUREIDCHILD | VARCHAR2 (6 Bytes) | Structure of child node | PK. “FK” indicates whether child is a SYS, BDRV, or APP |
IDCHILD | NUMBER | ID of child node | PK. FK SYSID in PV_SYSTEM, or FK APPID in PV_APPLICATION, or FK BDRVID in PV_BDRV |
SINCEDATE | DATE | Value validity start day | PK |
TODATE | DATE | Value validity end day | |
PARENTSHIPTYPEID | NUMBER | Parentship type ID | |
PARENTSHIPTYPE | VARCHAR2 (50 Bytes) | Parentship type name | |
HIERRULEID | NUMBER | Hierarchy rule id | |
HIERRULE | VARCHAR2 (50 Bytes) | Hierarchy rule name |
PV_ENT_LOOKUP
Column Name | Data Type |
|---|---|
| SRCID | NUMBER |
| SRCIDSHARELOOKUP | NUMBER |
| LOOKUPFIELD | VARCHAR |
| LOOKUPVALUE | VARCHAR |
| STRUCTUREID | VARCHAR |
| ID | NUMBER |
| INSERTTS | DATE |
| ACTIVITYDATE | DATE |
| DATASOURCENAME | VARCHAR |
| ETLMODID | NUMBER |
| ETLMODULE | VARCHAR |
| OWNERSHIP | NUMBER |
| COMPONENTID | NUMBER |
| COMPONENTNAME | VARCHAR |
PV_TASK
Column Name | Data Type |
|---|---|
| TASKID | NUMBER |
| NAME | VARCHAR2(250 CHAR) |
| DESCRIPTION | VARCHAR2(4000 CHAR) |
| ENABLED | NUMBER(1) |
| TASKTYPEID | NUMBER |
| TASKTYPE | VARCHAR2(50 CHAR) |
| PERIOD | NUMBER |
| SCHEDULERID | NUMBER |
| SRCID | NUMBER |
| COMPONENTID | NUMBER |
| COMPONENT_NAME | VARCHAR2(250 CHAR) |
| COMPTYPEID | NUMBER |
| COMPTYPE | VARCHAR2(50 CHAR) |
| STATUS | VARCHAR2(250 CHAR) |
| EXITCODE | VARCHAR2(25 CHAR) |
| LASTEXECTS | DATE |
| NEXTEXECTS | DATE |
| TASKIDPARENT | NUMBER |
PV_TASK_RUN
Column Name | Data Type |
|---|---|
| TASKRUNID | NUMBER |
| TASKID | NUMBER |
| NAME | VARCHAR2(250 CHAR) |
| TASKIDPARENT | NUMBER |
| EXECTS | DATE |
| EXITCODE | VARCHAR2(25 CHAR) |
| STATUS | VARCHAR2(250 CHAR) |
| DURATION | NUMBER |
| EXTRACTDURATION | NUMBER |
| LOADDURATION | NUMBER |
| CREATEDENTITIES | NUMBER |
| CONFDATALOADED | NUMBER |
| TSDATALOADED | NUMBER |
| OBJRELDATALOADED | NUMBER |
| LOADEDENTITIES | NUMBER |
| TASKEXECREQID | NUMBER |
| EXECPCT | NUMBER |
| ACCOUNTID | NUMBER |
| ACCOUNT | VARCHAR2(50 CHAR) |
PV_APPL_CONF_VARIATION
Column Name | Data Type |
|---|---|
| APPMETRICID | NUMBER |
| SINCEDATE | DATE |
| TODATE | DATE |
| VALUE | VARCHAR2(4000 CHAR) |
| INSERTTS | DATE |
| UPDATETS | DATE |
PV_APPL_CONF_LAST
Column Name | Data Type |
|---|---|
| APPMETRICID | NUMBER |
| SINCEDATE | DATE |
| TODATE | DATE |
| VALUE | VARCHAR2(4000 CHAR) |
| INSERTTS | DATE |
| UPDATETS | DATE |
PV_ANALYSIS_STAT_PROD
| Column Name | Data Type |
|---|---|
| STATPRODID | NUMBER |
| STATPRODKEY | VARCHAR2(250 CHAR) |
| PLOTID | NUMBER |
| NAME | VARCHAR2(250 CHAR) |
| DESCRIPTION | VARCHAR2(4000 CHAR) |
| TEMPLID | NUMBER |
| TEMPLNAME | VARCHAR2(250 CHAR) |
| TYPEID | NUMBER |
| TYPENAME | VARCHAR2(50 CHAR) |
| TIMEFILTERID | VARCHAR2(4000 CHAR) |
| TIMEFILTERNAME | VARCHAR2(250 CHAR) |
| CUSTOMTIMERANGE | VARCHAR2(4000 CHAR) |
PV_AUDIT_MESSAGE
| Column Name | Data Type |
|---|---|
| AUDITGROUPID | NUMBER |
| AUDITGROUPNAME | VARCHAR2(50 CHAR) |
| AUDITMSGID | NUMBER |
| TS | DATE |
| AUDITACTIONID | NUMBER |
| ACTIONNAME | VARCHAR2(50 CHAR) |
| ACTIONDESCR | VARCHAR2(250 CHAR) |
| ACCOUNTID | NUMBER |
| ACCOUNTNAME | VARCHAR2(50 CHAR) |
| ACCOUNTFULLNAME | VARCHAR2(50 CHAR) |
| COMPONENT | VARCHAR2(250 CHAR) |
| COMPONENTTYPE | VARCHAR2(50 CHAR) |
| SUBCOMPONENT | VARCHAR2(249) |
| IDSTR | VARCHAR2(250 CHAR) |
| MESSAGE | VARCHAR2(4000 CHAR) |
| ELAPSED | NUMBER |
| HOSTID | NUMBER |
| HOSTNAME | VARCHAR2(250 CHAR) |
Event-related views
PV_EVENT
This view contains information on events.
Column Name | Data Type | Description |
|---|---|---|
TS | DATE | Timestamp |
EVENTTYPEID | NUMBER | Event type ID |
EVENTTYPENAME | VARCHAR2 (50 Bytes) | Event type name |
EVENTSUBTYPEID | NUMBER | Event subtype ID |
EVENTSUBTYPENAME | VARCHAR2 (50 Bytes) | Event subtype name |
EVENTID | NUMBER | Event ID |
EVENTTS | DATE | Event date |
INTERVENTTS | DATE | |
RESOLUTIONTS | DATE | |
EVENTNAME | VARCHAR2 (250 Bytes) | |
EVENTDESC | VARCHAR2 (4000 Bytes) | |
NOTE | VARCHAR2 (4000 Bytes) | |
COLOR | VARCHAR2 (50 Bytes) | |
PERIOD | NUMBER | |
PERIODSINCEDATE | DATE | |
PERIODTODATE | DATE) | |
SEVERITY | VARCHAR2 (50 Bytes) | |
STATUS | VARCHAR2 (50 Bytes) | |
SERVICEUNAVAILABILITY | NUMBER | |
PENDINGTIMEMILLIS | NUMBER | |
INTERVENTTIMEMILLIS | NUMBER | |
RESOLUTIONTIMEMILLIS | NUMBER | |
SOURCECLASS | VARCHAR2 (512 Bytess) | |
SRCEVENTID | VARCHAR2 (50 Bytess) | |
COUNTOCCURRENCE | NUMBER |
PV_EVENT_OBJECT
This view contains information on the object related to an event.
Column Name | Data Type |
|---|---|
EVENTID | NUMBER |
OBJNAME | VARCHAR2 (50 Bytes) |
REFERREDID | NUMBER |
Domain-related views
PV_APPLICATION
This view contains information on domains.
Column Name | Data Type | Description | Key column |
|---|---|---|---|
APPID | NUMBER | Domain ID | PK |
APPLNAME | VARCHAR2 (50 Bytes) | Domain name | |
APPLDESCRIPTION | VARCHAR2 (250 Bytes) | Domain description | |
GROUPID | NUMBER | Domain group ID | FK in PV_APPLICATION |
GROUPNAME | VARCHAR2 (50 Bytes) | Domain group name | |
GROUPDESCRIPTION | VARCHAR2 (250 Bytes) | Domain group description |
PV_APPL_BDRV
Use this view to join PV_APPLICATION and PV_BDRV_METRIC, in order to retrieve metrics of all the business drivers owned by a certain domain.
Column Name | Data Type | Description |
|---|---|---|
BDRVID | NUMBER | Business driver ID |
APPID | NUMBER | Domain ID |
PV_APPL_EVENT
Use this view to join PV_APPLICATION and PV_EVENT, in order to retrieve events as per domains.
Column Name | Data Type | Description |
|---|---|---|
TS | DATE | Timestamp |
EVENTTYPEID | NUMBER | |
EVENTTYPENAME | VARCHAR2 (50 Bytes) | |
EVENTSUBTYPEID | NUMBER | |
EVENTSUBTYPENAME | VARCHAR2 (50 Bytes) | |
EVENTID | NUMBER | |
EVENTTS | DATE | |
INTERVENTTS | DATE | |
RESOLUTIONTS | DATE | |
EVENTNAME | VARCHAR2 | |
EVENTDESC | VARCHAR2 | |
NOTE | VARCHAR2 (4000 Bytes) | |
COLOR | VARCHAR2 (50 Bytes) | |
PERIOD | NUMBER | |
PERIODSINCEDATE | DATE | |
PERIODTODATE | DATE | |
SEVERITY | VARCHAR2 (50 Bytes) | |
STATUS | VARCHAR2 (50 Bytes) | |
SERVICEUNAVAILABILITY | NUMBER | |
PENDINGTIMEMILLIS | NUMBER | |
INTERVENTTIMEMILLIS | NUMBER | |
RESOLUTIONTIMEMILLIS | NUMBER | |
SOURCECLASS | VARCHAR2 (512 Bytes) | |
SRCEVENTID | VARCHAR2 (50 Bytes) | |
COUNTOCCURRENCE | NUMBER | |
APPID | NUMBER | |
APPLNAME | VARCHAR2 (250 Bytes) | |
APPLDESCRIPTION | VARCHAR2 (4000 Bytes) | |
GROUPID | NUMBER | |
GROUPNAME | VARCHAR2 (250 Bytes) | |
GROUPDESCRIPTION | VARCHAR2 (4000 Bytes) |
PV_APPL_SYS
Use this view to join PV_APPLICATION and PV_SYS_METRIC, in order to retrieve the metrics of all the systems owned by a certain domain.
Column Name | Data Type | Description | Key column |
|---|---|---|---|
SYSID | NUMBER | System ID | PK. FK SYSID in PV_SYSTEM |
APPID | NUMBER | Domain ID | PK. FK APPID in PV_APPLICATION |
PV_APPL_METRIC
Use this view to retrieve metric instances owned by a certain domain. This view contains one row per metric instance, keyed by APPMETRICID.
Column Name | Data Type | Description |
|---|---|---|
APPID | NUMBER | Domain ID |
APPLTYPE | VARCHAR2 (50 Bytes) | Type of the domain, as in PV_APPLICATION |
APPLTYPEID | NUMBER | Domain type ID, as in PV_APPLICATION |
APPMETRICID | NUMBER | An internal unique BMC Helix Capacity Optimization-generated identifier for the metric instance |
DESCRIPTION | VARCHAR2 (250 Bytes) | Domain description |
LOCATIONID | NUMBER | Location ID for the metric instance, if any; default 0 |
LOCATIONNAME | VARCHAR2 (50 Bytes) | Location name that goes with the location ID, if any; default UNKNOWN |
METRIC | VARCHAR2 (50 Bytes) | Metric name, uniquely identifying the metric of this metric instance |
METRICNAME | VARCHAR2 (50 Bytes) | Metric full name |
NAME | VARCHAR2 (50 Bytes) | Domain name |
SUBMETRICNAME | VARCHAR2 (512 Bytes) | Metric sub-object name, valid only for metrics with sub-objects |
VALTYPE | VARCHAR2 (50 Bytes) | Value type (count, rate,..) that goes with the Value type ID |
VALTYPEID | NUMBER | Value type ID for time series metrics (see table of metric value types). For conf series metrics, the VALTYPEID is always 5. See PV_CAT_VAL_TYPE. |
PV_APPL_WKLD
| Column Name | Data Type |
|---|---|
APPID | NUMBER |
| WKLDID | NUMBER |
Optimizer alert views
PV_RM_ALERT_LOG
Use the view to join PV_RM and PV_ALERT_LOG, in order to retrieve the metrics of all the systems owned by a certain domain.
| Column Name | Data Type | Description |
|---|---|---|
| RMALERTID | NUMBER | Optimizer Alert rule ID |
| RMALERTNAME | VARCHAR | Optimizer Alert rule name |
| TS | DATE | Alert triggering date |
| STRUCTUREID | VARCHAR | Structure of alerted entity |
| ID | NUMBER | ID of alerted entity |
| TYPEID | NUMBER | Alerted entity type ID |
| NAME | VARCHAR | Name of the alerted entity |
| STATUSID | NUMBER | Status ID of the alerted entity |
| RMALERTSTATUSID | NUMBER | Assigned alert status ID |
| RMALERTSTATUSNAME | VARCHAR | Assigned alert status name (OK,WARNING, and CRITICAL) |
| RMALERTREASON | VARCHAR | Alert reason |
| LASTRUNTS | DATE | Last execution date of the rule |
PV_RM_RECOMM
| Column Name | Data Type |
|---|---|
| STRUCTUREID | VARCHAR2(6 CHAR) |
| ENTID | NUMBER |
| RMALERTID | NUMBER |
| RMALERT | VARCHAR2(50 CHAR) |
| RMALERTTYPE | VARCHAR2(250 CHAR) |
| CATEGORY | VARCHAR2(50) |
| SEVERITY | VARCHAR2(50 CHAR) |
| SEV_INDEX | NUMBER |
| RMALERTTEMPLID | NUMBER |
| RMALERTTEMPL | VARCHAR2(250 CHAR) |
| PRIORITY | NUMBER |
| TS | DATE |
| SMALLDESCRIPTION | VARCHAR2(4000 CHAR) |
| DESCRIPTION | VARCHAR2(4000 CHAR) |
| RECOMMENDATION | VARCHAR2(4000 CHAR) |
| RESOURCES | VARCHAR2(250 CHAR) |
PV_RM_RULE
| Column Name | Data Type |
|---|---|
| RMALERTID | NUMBER |
| INSERTTS | DATE |
| NAME | VARCHAR2(50 CHAR) |
| DESCRIPTION | VARCHAR2(250 CHAR) |
| LASTRUNTS | DATE |
| RMALERTTEMPLID | NUMBER |
| RMALERTTEMPL | VARCHAR2(250 CHAR) |
ETL-related views
PV_ETL
| Column Name | Data Type |
|---|---|
| TASKID | NUMBER |
| NAME | VARCHAR2(250 CHAR) |
| DESCRIPTION | VARCHAR2(4000 CHAR) |
| ENABLED | NUMBER(1) |
| TASKTYPEID | NUMBER |
| TASKTYPE | VARCHAR2(50 CHAR) |
| PERIOD | NUMBER |
| SCHEDULERID | NUMBER |
| SRCID | NUMBER |
| ETLMODID | NUMBER |
| COMPONENTID | NUMBER |
| COMPONENT_NAME | VARCHAR2(250 CHAR) |
| COMPTYPEID | NUMBER |
| COMPTYPE | VARCHAR2(50 CHAR) |
| STATUS | VARCHAR2(250 CHAR) |
| EXITCODE | VARCHAR2(25 CHAR) |
| LASTEXECTS | DATE |
| NEXTEXECTS | DATE |
| TASKIDPARENT | NUMBER |
| ETLMODULE | VARCHAR2(250 CHAR) |
| ETLMODTYPE | VARCHAR2(20 CHAR) |
| ETLMODPACKAGE | VARCHAR2(250 CHAR) |
| ETLMODVENDOR | VARCHAR2(250 CHAR) |
PV_ETL_RUN
| Column Name | Data Type |
|---|---|
| TASKRUNID | NUMBER |
| TASKID | NUMBER |
| NAME | VARCHAR2(250 CHAR) |
| TASKIDPARENT | NUMBER |
| EXECTS | DATE |
| EXITCODE | VARCHAR2(25 CHAR) |
| STATUS | VARCHAR2(250 CHAR) |
| DURATION | NUMBER |
| EXTRACTDURATION | NUMBER |
| LOADDURATION | NUMBER |
| CREATEDENTITIES | NUMBER |
| CONFDATALOADED | NUMBER |
| TSDATALOADED | NUMBER |
| OBJRELDATALOADED | NUMBER |
| LOADEDENTITIES | NUMBER |
| TASKEXECREQID | NUMBER |
| EXECPCT | NUMBER |
| ACCOUNTID | NUMBER |
| ACCOUNT | VARCHAR2(50 CHAR) |
Forecast Model-related views
PV_FORECAST_MODEL_DETAILS
| Column Name | Data Type |
|---|---|
| TCID | NUMBER |
| TIMEFILTERID | VARCHAR2(4000 CHAR) |
| TIMEFILTERNAME | VARCHAR2(250 CHAR) |
| TIMEBACK | VARCHAR2(4000 CHAR) |
| TIMEFWD | VARCHAR2(4000 CHAR) |
| ALGORITHMTYPE | VARCHAR2(4000 CHAR) |
| ALGORITHMNAME | VARCHAR2(4000 CHAR) |
| MANUALTHRESHOLD | VARCHAR2(4000 CHAR) |
Model-related views
PV_MODEL_STAT_PROD
| Column Name | Data Type |
|---|---|
| STATUSID | NUMBER |
| STATUS | VARCHAR2(50 CHAR) |
| STATPRODKEY | VARCHAR2(250 CHAR) |
| TCID | NUMBER |
| MODELID | NUMBER |
| NAME | VARCHAR2(503 CHAR) |
| DESCRIPTION | VARCHAR2(4000 CHAR) |
| MODELNAME | VARCHAR2(250 CHAR) |
| MODELDESCRIPTION | VARCHAR2(4000 CHAR) |
| MODELTYPEID | NUMBER |
| MODELTYPENAME | VARCHAR2(50) |
| TCNAME | VARCHAR2(250 CHAR) |
| TCDESCRIPTION | VARCHAR2(4000 CHAR) |
| STATPRODID | NUMBER |
Object Map-related views
PV_OBJ_MAP_DATA_CUST_STAT
| Column Name | Data Type | Description |
|---|---|---|
| SERIESIDPRI | VARCHAR2(512 CHAR) | |
| STRUCTUREIDSEC | VARCHAR2(6 CHAR) | |
| SERIESIDSEC | VARCHAR2(512 CHAR) | |
| STATID | NUMBER | |
| TS | DATE | |
| VALUE | NUMBER | |
| COUNTSAMPLE | NUMBER | |
| STRINGVALUE | VARCHAR2(250 CHAR) | |
| STATPRODID | NUMBER | |
| NAME | VARCHAR2(50 CHAR) | |
| DESCRIPTION | VARCHAR2(250 CHAR) | |
| VALTYPEID | NUMBER | See PV_CAT_VAL_TYPE. |
| OWNERSHIP | NUMBER | |
| STRUCTUREIDPRI | VARCHAR2(6 CHAR) |
Reservation-related views
PV_RESERVATION
This view contains the list of reservations. Resource requirements are the sum of requested capacity of all "reservation components" for a certain reservation.
| Column Name | Data Type | Key column |
|---|---|---|
RSVID | NUMBER | X |
NAME | VARCHAR | |
| EXTERNALID | NUMBER | |
CONTAINERPOOLIDS | VARCHAR | |
CONTAINERPOOLNAMES | VARCHAR | |
DESCRIPTION | VARCHAR | |
INSERTTS | DATE | |
UPDATETS | DATE | |
PRIORITY | NUMBER | |
PRIORITYSTRING | VARCHAR | |
| START_DATE | DATE | |
| END_DATE | DATE | |
STATUSID | NUMBER | Mapped to accepted, pending, committed, rejected, expired |
STATUS | VARCHAR | |
RSVALERTSTATUS | VARCHAR | |
| RSVALERTSTATUSID | NUMBER | |
RSVALERTSTATUS_DESCRIPTION | VARCHAR | |
OWNER | VARCHAR | |
CPUMHZ | NUMBER | |
MEMORY | NUMBER | |
| DISK | NUMBER | |
VCPUNUM | NUMBER | |
CPUCORES | NUMBER | |
| CPUMHZCAPACITY | NUMBER | |
| MEMECAPACITY | NUMBER | |
| DSKCAPACITY | NUMBER | |
| LCPUCAPACITY | NUMBER | |
| CPUENTCCAPACITY | NUMBER | |
ALERTEDCONTAINERS | VARCHAR | |
| TENANT | VARCHAR |
PV_CAPACITY_POOL
This view contains the list of capacity pools.
| Column Name | Data Type |
|---|---|
| SYSID | NUMBER |
NAME | VARCHAR |
| DESCRIPTION | VARCHAR |
| SYSTYPEID | NUMBER |
| SYSTYPE | VARCHAR |
| RESERVATIONAVAILABILITY | VARCHAR |
| RSVALERTSTATUSID | NUMBER |
| RSVALERTSTATUS | VARCHAR |
| RSVALERTSTATUSDESCRIPTION | VARCHAR |
| RSVALERTSTATTS | DATE |
| PENDINGRSVNUM | NUMBER |
| COMMITTEDRSVNUM | NUMBER |
| CONTAINERSNUM | NUMBER |
PV_CONTAINER_POOL_RSVCONTAINER
| Column Name | Data Type |
|---|---|
| CONTAINERPOOLID | NUMBER |
| RSVCONTAINERID | NUMBER |
PV_RSV_CAPACITY_POOL
This view contains the list of capacity pools.| Column Name | Data Type |
|---|---|
| CONTAINERPOOLID | NUMBER |
RSVID | NUMBER |
PV_RSV_CONTAINER
This view contains the list of capacity containers.
| Column Name | Data Type | Key column |
|---|---|---|
SYSID | NUMBER | RSV_CONTAINER.SYSID (FK) |
NAME | VARCHAR | SYS_DEF.NAME |
SYSTYPEID | NUMBER | |
| STATUSID | NUMBER | |
RSVTYPEID | NUMBER | |
RSVALERTSTATUSID | NUMBER | |
RSVALERTTS | DATE | |
CONTAINERPOOLIDS | VARCHAR | |
CONTAINERPOOLNAMES | VARCHAR | |
| GMONNUM | NUMBER | |
| VCPUONNUM | NUMBER | |
SPAREVM_ALLOCATION | NUMBER | |
SPAREVM_UTILIZATION | NUMBER | |
SPAREVMP1_ALLOCATION | NUMBER | |
SPAREVMP1_UTILIZATION | NUMBER | |
SPAREVMP2_ALLOCATION | NUMBER | |
SPAREVMP2_UTILIZATION | NUMBER | |
LIMITINGRESOURCE_ALLOCATION | VARCHAR | |
LIMITINGRESOURCE_UTILIZATION | VARCHAR | |
COMMITTEDRESERVATIONS | NUMBER | |
PENDINGRESERVATIONS | NUMBER | |
| SPAREVM_BASIS | VARCHAR |
PV_RSV_ONBOARDING
Lists all On-boarding events. For each onboarding reports destination container, date of on-boarding, and total additional capacity provided.
Column Name | Data Type | Key column |
|---|---|---|
| RSVONBOARDINGID | NUMBER | X |
| NAME | VARCHAR | |
| DESCRIPTION | VARCHAR | |
| INSERTTS | DATE | |
| UPDATETS | DATE | |
| ONBOARDING_DATE | DATE | |
| OFFBOARDING_DATE | DATE | |
| STATUSID | NUMBER | |
| STATUS | VARCHAR | |
| NUM | NUMBER | |
| CPU_TOTAL_MHZ | NUMBER | |
| CPU_NUM | NUMBER | |
| TOTAL_REAL_MEM | NUMBER | |
| DISK_SIZE | NUMBER | |
| CONTAINERID | NUMBER | |
| CONTAINERNAME | VARCHAR | |
| RSVTYPEID | NUMBER | |
| PROVISIONTS | DATE | |
| RSVCONTAINERID | NUMBER | RSV_CONTAINER.SYSID |
| RSVCONTAINERNAME | VARCHAR | |
| CONTAINERPOOLID | NUMBER | |
| CONTAINERNAME | VARCHAR |
PV_RSV_ONBOARDING_SYS
Associates, for each on-boarding event, all "templates" included into an onboarding
Column Name | Data Type | Key column |
|---|---|---|
| SYSID | NUMBER | SYS_DEF.SYSID |
| NAME | VARCHAR | |
| DESCRIPTION | VARCHAR | |
| SYSTYPEID | NUMBER | |
| RSVONBOARDINGID | NUMBER | RSV_ONBOARDING.RSVONBOARDINGID |
| NUM | NUMBER | |
| CPU_TOTAL_MHZ | NUMBER | |
| CPU_NUM | NUMBER | |
| TOTAL_REAL_MEM | NUMBER | |
| DISK_SIZE | NUMBER | |
| OS | VARCHAR |
PV_RSV_RSVITEM
| Column Name | Data Type |
|---|---|
| RSVITEMID | NUMBER |
RSVITEMNAME | VARCHAR |
| TEMPLATEID | NUMBER |
| SYSID | NUMBER |
| TEMPLATENAME | VARCHAR |
| SYSTYPEID | NUMBER |
| SYSTYPE | VARCHAR |
| SERVICEID | NUMBER |
| SERVICENAME | VARCHAR |
| RSVID | NUMBER |
| CONGTAINERID | NUMBER |
| CONTAINERNAME | VARCHAR |
| CONTAINERTYPEID | NUMBER |
| VCPUNUM | NUMBER |
| CPUMHZ | NUMBER |
| CPUMHZCAPACITY | NUMBER |
| CPUCORES | NUMBER |
| CPUENTCCAPACITY | NUMBER |
| LCPUCAPACITY | NUMBER |
| MEMORY | NUMBER |
| MEMCAPACITY | NUMBER |
| DISK | NUMBER |
| DISKCAPACITY | NUMBER |
| OSTYPE | VARCHAR |
| CONTAINERPOOLID | NUMBER |
| CONTAINERPOOLNAME | VARCHAR |
| SYSIDREAL | NUMBER |
| SYSNAMEREAL | VARCHAR |
| SYSTYPEIDREAL | NUMBER |
PV_RSV_RSVTEMPLATE
| Column Name | Data Type |
|---|---|
| STRUCTUREID | NUMBER |
XID | NUMBER |
| NAME | VARCHAR |
| SYSTYPEID | NUMBER |
| SYSTYPE | NUMBER |
| RSVID | NUMBER |
| NUM | NUMBER |
| CPUMHZ | NUMBER |
| CPUCORES | NUMBER |
| VCPUNUM | NUMBER |
| MEMORY | NUMBER |
| DISK | NUMBER |
| CPUMHZCAPACITY | NUMBER |
| MEMCAPACITY | NUMBER |
| DISKCAPACITY | NUMBER |
| LCPUCAPACITY | NUMBER |
| CPUENTCCAPACITY | NUMBER |
| OS | VARCHAR |
PV_RSV_SYS_TEMPLATE
| Column Name | Data Type |
|---|---|
| SYSID | NUMBER |
NAME | VARCHAR |
| SYSTYPEID | NUMBER |
| SYSTYPE | VARCHAR |
| CPUMHZ | NUMBER |
| CPUCORES | NUMBER |
| VCPUNUM | NUMBER |
| MEMORY | NUMBER |
| DISK | NUMBER |
| CPUMHZCAPACITY | NUMBER |
| MEMCAPACITY | NUMBER |
| DSKCPACITY | NUMBER |
| CPUENTCCAPACITY | NUMBER |
| LCPUCAPACITY | NUMBER |
| OS | VARCHAR |
| USED_INTO_RESERVATIONS | VARCHAR |
PV_RSV_SERVICE_TEMPLATE
| Column Name | Data Type |
|---|---|
| SERVICEID | NUMBER |
NAME | VARCHAR |
| TYPEID | NUMBER |
| TYPE | VARCHAR |
| CPUMHZ | NUMBER |
| CPUCORES | NUMBER |
| VCPUNUM | NUMBER |
| MEMORY | NUMBER |
| DISK | NUMBER |
| CPUMHZCAPACITY | NUMBER |
| MEMCAPACITY | NUMBER |
| DSKCPACITY | NUMBER |
| CPUENTCCAPACITY | NUMBER |
| LCPUCAPACITY | NUMBER |
| OS | VARCHAR |
| USED_INTO_RESERVATIONS | VARCHAR |
PV_RSV_COMPONENTS_CONTAINER
For each reservation, reports all "reservation components" with required resources, involved container (according to reservation status) and its alert status (if any). (join between RSV_SYS_CONTAINER and RSV_APP(SYS)_DATA and RSV_CONTAINER)
| Column Name | Description | Key column |
|---|---|---|
| RSVID | RSV_DEF.RSVID (FK) | |
| SYSID | RSV_SYS.SYSID (FK) | |
| APPID | RSV_APP.APPID (FK) | |
| INSTANCEID | ||
| NAME | SYS_DEF.NAME | |
| RSVNAME | RSV_DEF.NAME | |
| RSVCONTAINERID | can be null | (FK) RSV_CONTAINER.SYSID |
| RSVCONTAINERNAME | can be null | |
| VCPU_NUM | ||
| CPU_MHZ | ||
| CPU_ENTITLEMENT | ||
| CPU_SPECINT | ||
| MEMORY | ||
| STORAGE | ||
| RSVALERTSTATUSID | alert status of container | RSV_ALERT_STATUS.RSVALERTSTATUSID |
| RSVALERTTS |
Indicator-related views
PV_SYS_INDICATOR
| Column Name | Description |
|---|---|
| SYSID | |
| SYSMETRICID | |
| NAME | |
| DESCRIPTION | |
| SYSTYPEID | |
| SYSTYPE | |
| INDICATOR | objname |
| INDICATORNAME | resource counter name |
| SUBINDICATORNAME | subobjname |
| VALTYPEID | See PV_CAT_VAL_TYPE. |
| VALTYPE | |
| LASTVALUE | The last value of the indicator. Should be returned by the function. |
Tag-related views
PV_SYS_TAG
Describes tags that are placed on BMC Helix Capacity Optimization systems.
| Column Name | Description |
|---|---|
| SYSID | The id of the tagged system |
| SYSNAME | The name of the system |
| SYSTYPEID | The type of the system as id |
| SYSTYPE | The type of the system |
| TAG | The value of the tag |
| TAGTYPEID | The internal identifier of the tag type |
| TAGTYPENAME | The name of the tag type |
| DESCRIPTION | The description of the tag (if available) |
| INSERTTS | The insert timestamp of the tag |
| UPDATETS | The update timestamp of the tag |
PV_BDRV_TAG
Describes tags that are placed on BMC Helix Capacity Optimization business driver
| Column Name | Description |
|---|---|
| BDRVID | The id of the tagged business driver |
| BDRVNAME | The name of the business driver |
| BDRVTYPEID | The type of the business driver as id |
| BDRVTYPE | The type of the business driver |
| TAG | The value of the tag |
| TAGTYPEID | The internal identifier of the tag type |
| TAGTYPE | The type of the tag |
| DESCRIPTION | The description of the tag (if available) |
| INSERTTS | The insert timestamp of the tag |
| UPDATETS | The update timestamp of the tag |
PV_APPL_TAG
Describes tags that are placed on BMC Helix Capacity Optimization domain.
| Column Name | Description |
|---|---|
| APPID | The id of the tagged domain |
| NAME | The name of the domain |
| APPLTYPEID | The type of the domain as id |
| APPLTYPE | The type of the domain |
| TAG | The value of the tag |
| TAGID | The internal identifier of the tag |
| TAGTYPENAME | The type of the tag |
| TAGTYPEID | The ID of the tag type |
| TAGTYPECOLOR | The color of the tag type |
| DESCRIPTION | The description of the tag (if available) |
| INSERTTS | The insert timestamp of the tag |
| UPDATETS | The update timestamp of the tag |
PV_REP_TAG
Describes tags that are placed on BMC Helix Capacity Optimization report.
| Column Name | Description |
|---|---|
| REPID | The id of the tagged report |
| REPNAME | The name of the report |
| REPTYPE | The type of the report |
| TAG | The value of the tag |
| TAGTYPEID | The internal identifier of the tag type |
| TAGTYPE | The type of the tag |
| DESCRIPTION | The description of the tag (if available) |
| INSERTTS | The insert timestamp of the tag |
| UPDATETS | The update timestamp of the tag |
PV_REP_RUN
| Column Name | Description |
|---|---|
| REPID | The id of the tagged report |
| REPNAME | The name of the report |
| REPTYPE | The type of the report |
| TAG | The value of the tag |
| TAGTYPEID | The internal identifier of the tag type |
| TAGTYPE | The type of the tag |
| DESCRIPTION | The description of the tag (if available) |
| INSERTTS | The insert timestamp of the tag |
| UPDATETS | The update timestamp of the tag |
PV_REPORT
| Column Name | Description |
|---|---|
| REPID | NUMBER |
| INSERTTS | DATE |
| NAME | VARCHAR2(250 CHAR) |
| DESCRIPTION | VARCHAR2(4000 CHAR) |
| REPTEMPLID | NUMBER |
| REPTEMPL | VARCHAR2(250 CHAR) |
| REPTYPEID | NUMBER |
| REPTYPE | VARCHAR2(50 CHAR) |
| ACCOUNTID | NUMBER |
| ACCOUNT | VARCHAR2(50 CHAR) |
| FOLDERID | NUMBER |
| FOLDER | VARCHAR2(250 CHAR) |
Public Function Package
You can extract dynamic thresholds defined for an entity within a custom SQL data mart. To do this, use the PFUNC package. PFUNC is a public function package that stores all functions that retrieve thresholds from a custom SQL data mart.
The following table lists all the functions available in PFUNC:
Name | Description | Mandatory fields |
|---|---|---|
pf_threshold_get_by_object(p_structureid, p_metricid, p_appid, p_ts) | Allow to retrieve threshold values by metric. | p_structureid, p_metricid |
pf_threshold_get_by_entity(p_structureid, p_id, p_metric, p_appid, p_ts) | Allow to retrieve threshold values for a certain metric by entity | p_structureid, p_id, p_metric |
pf_threshold_get_by_enttype(p_structureid, p_enttypeid, p_metric, p_appid) | Allow to retrieve threshold values for a certain metric by entity type. | p_structureid, p_enttypeid, p_metric |
pf_threshold_get_by_resource(p_metric, p_appid) | Allow to retrieve threshold values by metric | p_metric |
Comments
There's an error in the doc of Tag-related views. "Tagtype" column does not exist, while we have "tagtypename".
Thanks, Stefano. I have updated the column name.
Public view PV_APP_TAG does not exist, while we have PV_APPL_TAG
Thanks for the feedback, Stefano.
I have updated the view name.
Most public view PV_APPL_TAG's column names are not correct: APPNAME -> NAME APPTYPEID -> APPLTYPEID APPTYPE -> APPLTYPE TAGID missing TAGTYPECOLOR missing
Hello,
Thank you for pointing this out. I have corrected the column names in the PV_APPL_TAG view.
Regards,
Bharati
Hi, we would like to see the Metrics that are available on TSCO on a PV. We can see only the ones joined to systems on the PV_SYS_METRIC . We want to see all the metrics defined, and the custom ones.. etc... how can we avoid using the internal tables? Is there any PV table to get ALL the metrics?
Thank you for your feedback.
In Capacity Optimization, there is no PV table to view all the metrics that are available in the product. Please enter a request for a product enhancement in Communities (https://community.bmc.com/)
Thanks,
Bharati
table description missing for PV_APPL_METRIC
Hello Raffaele,
Thank you for bringing this to our attention.
I have added the table description for PV_APPL_METRIC.
Regards,
Manisha
Hello there, we've recently found that there's some useful information available from the SYS_DEF & WKLD_DEF tables in HCO (we've used them to filter entities by their STATUSID's).
I was only able to find out that these tables existed and could be queried from a mention on the BMC Communities pages.
Would it be possible to reference them and their columns here, please?
Hello Robert,
Thank you for the feedback.
We checked this with SMEs. They confirmed that the SYS_DEF & WKLD_DEF tables are internal tables; therefore, we don't document these tables. In case you are able to access them, you can continue to use them. However, BMC cannot guarantee that the structure of these tables will not change in the future.
Hope this helps. And my apologies for the delayed response.
Regards,
Manisha
Log in or register to comment.