IBMLicenseServiceBundledProductData Table

The IBMLicenseServiceBundledProductData table holds all of the data collected from the IBM Licensing Service for bundled products.

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 `IBMLicenseServiceBundledProductData` table
Database Column	Details
`Date`	Type: date. Key The date associated with the peak consumption.
`CloudPakID`	Type: unique identifier. Key The ID of the Cloud Pak associated with this product.
`CloudPakVersion`	Type: text (max 64 characters). Nullable The version of the Cloud Pak associated with this product.
`CloudPakMetricName`	Type: text (max 64 characters). Key The type of metric of the Cloud Pak associated with this product.
`ProductName`	Type: text (max 256 characters). Key The name of the product.
`ProductID`	Type: unique identifier. Key The ID of the product.
`MetricName`	Type: text (max 64 characters). Key The type of metric that is being represented.
`MetricMeasuredQuantity`	Type: big integer. Nullable The measured quantity before applying any Cloud Pak conversions.
`MetricConversion`	Type: text (max 32 characters). Key The ratio at which the product consumption is turned into the Cloud Pak consumption.
`MetricConvertedQuantity`	Type: big integer. Nullable The metric quantity after product to Cloud Pak consumption ratio has been applied.
`ClusterID`	Type: integer. Key The ClusterID associated with the licence data.
`SoftwareLicenseID`	Type: integer. Nullable The software license to which the IBM bundled product consumption may be linked. Foreign key to the `SoftwareLicense` table.
`SoftwareTitleID`	Type: integer. Nullable The software title that relates to the IBM bundled product consumption. Foreign key to the `SoftwareTitle` table.
`InstallerEvidenceID`	Type: integer. Nullable A unique identifier for an installer evidence record.