ReconcileIBMLicenseServiceProducts Table

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

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

Database Column



Type: integer. Key

The ClusterID associated with the licence data.


Type: text (max 64 characters). Key

The ID of the product.


Type: text (max 64 characters). Key

The type of metric that is being represented.


Type: integer. Key. Nullable

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


Type: text (max 64 characters). Key. Nullable

The ID of the product.


Type: integer. Nullable

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