Page tree
Skip to end of metadata
Go to start of metadata

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 TrueSight Capacity Optimization data in a simple and straightforward manner. The following sections describe these views in detail.

To view example queries developed using, and Chargeback reports based on these Public Views, see Related topics.

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 TrueSight 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 BMC TrueSight Capacity Optimization 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 TrueSight 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

 

STATUSIDNUMBERStatus 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 Metric sub-types in Agent.

A metric instance is created when data for a particular metric for a System is first loaded by a connector. It remains in BMC TrueSight 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 TrueSight 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 Metric sub-types in Agent 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 TrueSight Capacity Optimization, in the page Metric sub-types in Agent.

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 TrueSight 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 TrueSight Capacity Optimization, in the page Metric sub-types in Agent.

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

 

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

 

Category-related views

PV_CAT_APPL_TYPE

Column Name

Data Type

APPLTYPEIDNUMBER
NAMEVARCHAR2(50 CHAR)
DESCRIPTIONVARCHAR2(250 CHAR)
ENTTYPENMVARCHAR2(50 CHAR)
NAMEENVARCHAR2(50 CHAR)
PACKAGEVARCHAR2(250 CHAR)
VENDORVARCHAR2(250 CHAR)

PV_CAT_AUDIT_ACTION

Column Name

Data Type

AUDITACTIONIDNUMBER
NAMEVARCHAR2(50 CHAR)
DESCRIPTIONVARCHAR2(250 CHAR)
AUDITGROUPIDNUMBER
GROUPNAMEVARCHAR2(50 CHAR)

PV_CAT_BDRV_TYPE

Column Name

Data Type

BDRVTYPEIDNUMBER
NAMEVARCHAR2(50 CHAR)
DESCRIPTIONVARCHAR2(250 CHAR)
ENTTYPENMVARCHAR2(50 CHAR)
NAMEENVARCHAR2(50 CHAR)
PACKAGEVARCHAR2(250 CHAR)
VENDORVARCHAR2(250 CHAR)

PV_CAT_EVENT_TYPE

Column Name

Data Type

EVENTTYPEIDNUMBER
NAMEVARCHAR2(50 CHAR)
DESCRIPTIONVARCHAR2(250 CHAR)

PV_CAT_PARENTSHIP_TYPE

Column Name

Data Type

PARENTSHIPTYPEIDNUMBER
NAMEVARCHAR2(50 CHAR)
NODENAMEVARCHAR2(250 CHAR)
DIRECTIONNUMBER
PACKAGEVARCHAR2(250 CHAR)
VENDORVARCHAR2(250 CHAR)

PV_CAT_RM_RECOMM_TYPE

Column Name

Data Type

RMALERTTYPEIDNUMBER
NAMEVARCHAR2(250 CHAR)
DESCRIPTIONVARCHAR2(4000 CHAR)
PACKAGEVARCHAR2(250 CHAR)
VENDORVARCHAR2(250 CHAR)

PV_CAT_SYS_TYPE

Column Name

Data Type

DESCRIPTIONVARCHAR2(250 CHAR)
ENTTYPENMVARCHAR2(50 CHAR)
NAMEENVARCHAR2(50 CHAR)
PACKAGEVARCHAR2(250 CHAR)
VENDORVARCHAR2(250 CHAR)
SYSTYPEIDNUMBER
NAMEVARCHAR2(50 CHAR)

PV_CAT_VAL_TYPE

Column Name

Data Type

Description
VALTYPEIDNUMBER

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.

NAMEVARCHAR2(50 CHAR) 
DESCRIPTIONVARCHAR2(250 CHAR) 
DEFAULTPLOTCOLVARCHAR2(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

 

WEIGTH

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

 

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
(Basic Cost Object, Composite Cost Object)

COSTOBJKEY

NUMBER

Cost object key

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

 

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

 

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

Description

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_CONF_LAST

Use this view to retrieve the last value of Domain configuration metric instances .

 

PV_APPL_CONF_VARIATION

Use this view to view historical changes in Domain configuration metric instances.

 

PV_APPL_METRIC

Use this view to retrieve metric instances owned by a certain domain.

 

Resource monitor 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 NameData TypeDescription
RMALERTIDNUMBERResource Monitor Alert rule ID
RMALERTNAMEVARCHARResource Monitor Alert rule name
TSDATEAlert triggering date
STRUCTUREIDVARCHARStructure of alerted entity
IDNUMBERID of alerted entity
TYPEIDNUMBERAlerted entity type ID
NAMEVARCHARName of the alerted entity
STATUSIDNUMBERStatus ID of the alerted entity
RMALERTSTATUSIDNUMBERAssigned alert status ID
RMALERTSTATUSNAMEVARCHAR

Assigned alert status name

(OK,WARNING, and CRITICAL)
RMALERTREASONVARCHARAlert reason
LASTRUNTSDATELast execution date of the rule

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

DescriptionKey column

RSVID

NUMBER X

NAME

VARCHAR  

CONTAINERPOOLIDS

VARCHAR  

CONTAINERPOOLNAMES

VARCHAR  

DESCRIPTION

VARCHAR  

INSERTTS

DATE  

UPDATETS

DATE  

RSVTYPEID

NUMBER  

CLASSIFICATION

NUMBER  

PRIORITY

NUMBER  

PROVISIONTS

DATE  

DECOMMISSIONTS

DATE  

STATUSID

NUMBER Mapped to accepted, pending, committed, rejected, expired

STATUS

VARCHAR

 

 

RSVALERTSTATUS

VARCHAR

 

 

RSVALERTSTATUS_DESCRIPTION

VARCHAR

 

 

ACCOUNTID

NUMBER

 

 

PROBABILITY

NUMBER

 

 

EXTERNALID

VARCHAR

 

 

OWNER

VARCHAR

 

 

CPUMHZ

NUMBER

 

 

MEMORY

NUMBER

 

 

STORAGE

NUMBER

 

 

VCPUNUM

NUMBER

 

 

CPUCORES

NUMBER

 

 

ALERTEDCONTAINERS

VARCHAR

 

 

PV_RSV_CAPACITY_POOL

This view contains the list of capacity pools.

Column Name

Data Type

DescriptionKey column
CONTAINERPOOLIDNUMBER  

RSVID

NUMBER  

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 NameData typeDescriptionKey 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 containerRSV_ALERT_STATUS.RSVALERTSTATUSID
RSVALERTTS   

PV_RSV_CONTAINER

This view contains the list of capacity containers.

Column Name

Data Type

MeaningKey column

SYSID

NUMBER  RSV_CONTAINER.SYSID (FK)

NAME

VARCHAR

  SYS_DEF.NAME

SYSTYPEID

NUMBER

  

RSVTYPEID

NUMBER

  

RSVALERTSTATUS

VARCHAR

  

RSVALERTSTATUS_DESCRIPTION

VARCHAR

  

RSVALERTTS

DATE

  

CONTAINERPOOLIDS

VARCHAR

  

CONTAINERPOOLNAMES

VARCHAR

  

CPUTOTALMHZ

NUMBER

  

TOTALREALMEM

NUMBER

  

TOTALDSTORESIZE

NUMBER

  

CPUUTIL

NUMBER

  

MEMUTIL

NUMBER

  

TOTALDSTOREUTIL

NUMBER

  

GMONNUM

NUMBER

  

VCPUONNUM

NUMBER

  

SPAREVM

NUMBER

  

SPAREVMP1

NUMBER

  

SPAREVMP2

NUMBER

  

LIMITINGRESOURCE

VARCHAR

  

COMMITTEDRESERVATIONS

NUMBER

  

PENDINGRESERVATIONS

NUMBER

  

PV_RSV_CONTAINER_POOL

Maps each reservation with related container pool(s).

Column NameData TypeDescriptionKey column
RSVID RSD_DEF.RSVIDX
CONTAINERPOOLID CONTAINER_POOL.SYSID 

PV_CONTAINER_POOL_RSV_CONTAINER

Maps each capacity container with capacity pool(s).

Column Name

Data Type

Meaning

Key column

CONTAINERPOOLID CONTAINER_POOL.SYSIDX
RSVCONTAINERID RSV_CONTAINER.SYSIDX

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

Description

Key column

RSVONBOARDINGID  X
NAME   
DESCRIPTION   
INSERTTS   
UPDATETS   
RSVTYPEID   
PROVISIONTS   
DECOMMISSIONTS   
RSVCONTAINERID  RSV_CONTAINER.SYSID
RSVCONTAINERNAME   
CPU_NUM   
CPU_MHZ   
CPU_ENTITLEMENT   
CPU_SPECINT   
MEMORY   
STORAGE   

PV_RSV_ONBOARDING_SYS

Associates, for each on-boarding event, all "templates" included into an onboarding

Column Name

Data Type

Description

Key column

RSVONBOARDINGID  RSV_ONBOARDING.RSVONBOARDINGID
SYSID  SYS_DEF.SYSID
NUMBER   
CPU_NUM   
CPU_MHZ   
CPU_ENTITLEMENT   
CPU_SPECINT   
MEMORY   
STORAGE   

Indicator related views

PV_SYS_INDICATOR

Column NameDescription
SYSID 
SYSMETRICID 
NAME 
DESCRIPTION 
SYSTYPEID 
SYSTYPE 
INDICATORobjname
INDICATORNAMEresource counter name
SUBINDICATORNAMEsubobjname
VALTYPEIDSee PV_CAT_VAL_TYPE.
VALTYPE 
LASTVALUEThe last value of the indicator. Should be returned by the function.

PV_SYS_IND_DATA

 

PV_SYS_IND_METADATA

 

Tag related views

PV_SYS_TAG

Describes tags that are placed on BMC TrueSight Capacity Optimization systems

Column NameDescription
SYSIDThe id of the tagged system
SYSNAMEThe name of the system
SYSTYPEIDThe type of the system as id
SYSTYPEThe type of the system
TAGThe value of the tag
TAGTYPEIDThe internal identifier of the tag type
TAGTYPEThe type of the tag
DESCRIPTIONThe description of the tag (if available)
INSERTTSThe insert timestamp of the tag
UPDATETSThe update timestamp of the tag

PV_BDRV_TAG

Describes tags that are placed on BMC TrueSight Capacity Optimization business driver

Column NameDescription
BDRVIDThe id of the tagged business driver
BDRVNAMEThe name of the business driver
BDRVTYPEIDThe type of the business driver as id
BDRVTYPEThe type of the business driver
TAGThe value of the tag
TAGTYPEIDThe internal identifier of the tag type
TAGTYPEThe type of the tag
DESCRIPTIONThe description of the tag (if available)
INSERTTSThe insert timestamp of the tag
UPDATETSThe update timestamp of the tag

PV_APP_TAG

Describes tags that are placed on BMC TrueSight Capacity Optimization domain

Column NameDescription
APPIDThe id of the tagged domain
APPNAMEThe name of the domain
APPTYPEIDThe type of the domain as id
APPTYPEThe type of the domain
TAGThe value of the tag
TAGTYPEIDThe internal identifier of the tag type
TAGTYPEThe type of the tag
DESCRIPTIONThe description of the tag (if available)
INSERTTSThe insert timestamp of the tag
UPDATETSThe update timestamp of the tag

PV_REP_TAG

Describes tags that are placed on BMC TrueSight Capacity Optimization report

Column NameDescription
REPIDThe id of the tagged report
REPNAMEThe name of the report
REPTYPEThe type of the report
TAGThe value of the tag
TAGTYPEIDThe internal identifier of the tag type
TAGTYPEThe type of the tag
DESCRIPTIONThe description of the tag (if available)
INSERTTSThe insert timestamp of the tag
UPDATETSThe update timestamp of the tag

Public Function Package

You can extract dynamic thresholds defined for an entity within a custom SQL datamart. To do this, use the PFUNC package. PFUNC is a public function package that stores all functions that retrieve thresholds from a custom SQL datamart.

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.

Parameters:
- <p_structureid>: Could be SYS, WKLD, APP
- <p_metricid>: Is the identifier of metric that can be retrieved from PV_SYS_METRIC (sysmetricid) or PV_BDRV_METRIC (bdrvmetricid) or PV_APPL_METRIC (appmetricid)
- <p_appid>: To filter threshold by a specific domain
- <p_ts>: In case threshold has a configuration metricas limit, return the metric value at that date

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

Parameters:
- <p_structureid>: could be SYS, WKLD, APP
- <p_id>: is the identifier of system from PV_SYSTEM (sysid) or PV_BUSINESS_DRIVER (bdrvid) or PV_APPLICATION (appid)
- <p_metric>: is the name of metric that can be retrieved from PV_SYS_METRIC or PV_BDRV_METRIC or PV_APPL_METRIC (metric)
- <p_appid>: to filter threshold by a specific domain
- <p_ts>: in case threshold has as limit a configuration metric, return metric value at that date

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.

Parameters:
- <p_structureid>: Could be SYS, WKLD, APP
- <p_enttypeid>: Type of entity, can be SYSTYPEID or BDRVTYPEID or APPLTYPEID depending on p_structureid. See also PV_CAT_SYS_TYPE, PV_CAT_APPL_TYPE and PV_CAT_BDRV_TYPE
- <p_metric>: Is the name of metric that can be retrieved from PV_SYS_METRIC or PV_BDRV_METRIC or PV_APPL_METRIC (metric)
- <p_appid>: To filter threshold by a specific domain

p_structureid, p_enttypeid, p_metric

pf_threshold_get_by_resource(p_metric, p_appid)

Allow to retrieve threshold values by metric

Parameters:
- <p_metric>: Is the name of metric that can be retrieved from PV_SYS_METRIC or PV_BDRV_METRIC or PV_APPL_METRIC (metric)
- <p_appid>: To filter threshold by a specific domain

p_metric

Related topics

To view example queries developed using these public views, see Query Examples

To view Chargeback reports based on these Public Views, see Chargeback reports based on these Public Views