EntitlementRecommendation Table
EntitlementRecommendation
is a table listing all of the recommendations that have been made to link entitlements to licenses.
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.
Database Column |
Details |
---|---|
Entitlement RecommendationID
|
Type: integer. Key. Generated ID A unique identifier for this recommendation. |
SoftwareLicenseID
|
Type: integer. Key. Nullable The license affected by this recommendation, null if a new license is being created. Foreign key to the |
SoftwareLicense DefinitionID
|
Type: integer. Key. Nullable The license defintion of the new license being created. Foreign key to the |
SoftwareLicenseDefinition
|
Type: text. Nullable Encrypted XML definition of the customised license being created if any. |
MaintenanceDefinition
|
Type: text. Nullable Encrypted XML definition of the maintenance being applied to the license associated with this recommendation. |
ContractID
|
Type: integer. Key. Nullable The contract affected by this recommendation, if any. Foreign key to the |
MaintenanceContractID
|
Type: integer. Nullable The contract providing maintenance for this recommendation, if any. Foreign key to the |
ProcessActionID
|
Type: integer. Key. Nullable The action that is recommended by this recommendation. Foreign key to the |
Entitlement RecommendationStateID
|
Type: integer. Nullable The state that the recommendation is in. Foreign key to the |
CreationUser
|
Type: text (max 128 characters). Nullable The operator who created the record. |
CreationDate
|
Type: datetime The date the record was created. |
UpdatedUser
|
Type: text (max 128 characters). Nullable The operator who last updated the record. |
UpdatedDate
|
Type: datetime. Nullable The date the record was last updated. |
DoTransferSoftware LicenseAllocations
|
Type: boolean. Nullable Indicates whether to transfer Group Assignments and Allocations when performing an upgrade and all the entitlements are transferred to the new license. |