EntitlementTransactionOtherCandidate Table

EntitlementTransactionOtherCandidate is a table listing all of the other possible license recommendations that have been made to for entitlements.

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

Database Column

Details

EntitlementTransaction OtherCandidateID

Type: integer. Key. Generated ID

A unique identifier for this possible candidate.

EntitlementTransactionID

Type: integer. Key

The entitlement the recommendation belongs to.

SoftwareLicenseID

Type: integer. Key

The license affected by this recommendation.

UpgradeFrom

Type: boolean

Indicates whether this license was a candidate to upgrade from or not.

LicenseNameMatched

Type: boolean

Indicates whether or not there was a license name match.

PrimaryApplicationMatched

Type: boolean

Indicates whether or not there was a primary application match.

AnyApplicationMatched

Type: boolean

Indicates whether or not there was a match on any application.

MaintenanceSettings Matched

Type: boolean

Indicates whether or not there was a match based on maintenance settings.

EnterpriseGroupMatched

Type: boolean

Indicates whether or not there was a match based on enterprise groups.

NumberOfVersionsDifferent

Type: integer

Indicated the number of versions between the version being upgraded to from the version being upgraded from.