ReconcileIBMLicenseServiceBundledProductData Table

A staging table which holds all of the data collected from the IBM Licensing Service during reconcile for bundled products which is bulk copied to IBMLicenseServiceBundledProductData.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for ReconcileIBMLicenseServiceBundledProductData table

Database Column

Details

Date

Type: date. Key

The date associated with the peak consumption.

CloudPakName

Type: text (max 512 characters). Key

The name of the Cloud Pak associated with this product.

CloudPakID

Type: text (max 512 characters)

The ID of the Cloud Pak associated with this product.

CloudPakVersion

Type: text (max 512 characters). Key

The version of the Cloud Pak associated with this product.

ProductName

Type: text (max 512 characters). Key

The name of the product.

ProductID

Type: text (max 512 characters)

The ID of the product.

MetricName

Type: text (max 512 characters)

The type of metric that is being represented.

MetricMeasuredQuantity

Type: integer

The measured quantity before applying any Cloud Pak conversions.

MetricConversion

Type: text (max 32 characters)

The ratio at which the product consumption is turned into the Cloud Pak consumption.

MetricConvertedQuantity

Type: integer

The metric quantity after product to Cloud Pak consumption ratio has been applied.

ClusterID

Type: integer. Key

The ClusterID associated with the licence data.