IBMLicenseServiceProductData Table

The IBMLicenseServiceProductData table holds all of the data collect from the IBM Licensing Service 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 IBMLicenseServiceProductData table

Database Column



Type: date. Key

The date associated with the peak consumption.


Type: text (max 256 characters). Key

The name of the product.


Type: unique identifier. Key

The ID of the product.


Type: text (max 64 characters). Key

The type of metric that is being represented.


Type: big integer. Nullable

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


Type: integer. Key

The ClusterID associated with the licence data.


Type: integer. Nullable

The software license to which the IBM product consumption may be linked. Foreign key to the SoftwareLicense table.


Type: integer. Nullable

The software title that relates to the IBM product consumption. Foreign key to the SoftwareTitle table.


Type: integer. Nullable

A unique identifier for an installer evidence record.