ImportedIBMLicenseServiceBundledProductData Table

This ImportedIBMLicenseServiceBundledProductData table stores imported bundled product data from the IBM Licence Service.

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 ImportedIBMLicenseServiceBundledProductData table

Database Column

Details

ComplianceConnectionID

Type: integer. Key. Nullable

The identifier for a data source connection in the ComplianceConnection table.

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.

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.

ClusterExternalID

Type: big integer. Key. Nullable

The ClusterExternalID associated with the product data. Foreign key to the ImportedCluster table.

ExternalInstallerID

Type: big integer. Key. Nullable

The identifier used in the source connection for the installer evidence. Foreign key to InstallerEvidence.