SoftwareLicenseType Table

SoftwareLicenseType holds the collection of all valid license types.

Table 1. Database columns for SoftwareLicenseType table

Database Column

Details
SoftwareLicenseTypeID

Type: integer. Key. Generated ID

A unique identifier for each SoftwareLicenseType. Possible values and the corresponding default strings are:

  • 1 = Enterprise
  • 2 = Device
  • 3 = Node-Locked
  • 4 = User
  • 5 = Concurrent User
  • 6 = Appliance
  • 7 = Client Server
  • 8 = OEM
  • 9 = Evaluation
  • 10 = Run-Time
  • 11 = Device (Processor-Limited)
  • 12 = Site
  • 13 = Named User
  • 14 = Device (Core-Limited)
  • 15 = Core Points
  • 16 = Oracle Processor
  • 17 = Oracle Named User Plus
  • 18 = Processor Points
  • 19 = Oracle Legacy
  • 20 = Enterprise Agreement
  • 21 = SAP Named User
  • 22 = Microsoft Server Processor
  • 23 = CAL Legacy
  • 24 = Tiered Device
  • 25 = IBM Processor Value Unit
  • 26 = IBM Authorized User
  • 27 = IBM Concurrent User
  • 28 = IBM Floating User
  • 29 = Custom Metric
  • 30 = Processor
  • 31 = IBM Resource Value Unit
  • 32 = IBM User Value Unit
  • 33 = Microsoft Server Core
  • 34 = Oracle User
  • 35 = SAP Package
  • 36 = Microsoft SCCM Client Device
  • 37 = Microsoft SCCM Client User
  • 38 = Microsoft Developer Network
  • 39 = Microsoft Device CAL
  • 40 = Microsoft User CAL
  • 41 = Microsoft Server/Management Core
  • 42 = SaaS User
  • 43 = IBM VPC
  • 44 = IBM RU
  • 45 = IBM MVS
TypeResourceName

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing a license type. Foreign key to the ComplianceResourceString table.
TypeDefaultValue

Type: text (max 100 characters)

The text to display if the type resource string has no translation.
XMLFile

Type: text. Nullable

The layout of the property dialog for this type of computer, stored in XML format.
CustomProcedureName

Type: text (max 256 characters). Nullable

The stored procedure used to assign licenses for this license type.
DoesLicenseAllowUser Allocations

Type: boolean

Set this field to True if the license supports allocations to individual end-users. When False, it cannot be allocated to end-users.
DoesLicenseAllow ComputerAllocations

Type: boolean

Set this field to True if the license supports allocations to individual computers. When it is False, it cannot be allocated to computers.
DoesLicenseAllow VirtualApplications

Type: boolean

Set this field to True if the license supports virtual applications. When it is False, it cannot be consumed by virtual applications. (Note that virtual applications have AccessModeID > 1.)
CanConvertToAndFromType

Type: boolean

Set this field to True if an operator is allowed to change the type of this license after it has been created. This field also determines whether this license type is included in the list of types that can be converted to. Oracle licenses, for example, cannot be converted to or from.
ExclusionReasonName

Type: text (max 256 characters). Nullable

The unique name of the localizable resource string representing the reason why an installation linked to a license of this type may appear in the Unlicensed Installs node. Foreign key to the ComplianceResourceString table.
ExclusionReasonDefault

Type: text (max 500 characters)

The text to display if the reason resource string has no translation.
IncludeInSQLAssignment

Type: boolean

Set this field to True if licenses of this type should be processed during the SQL part of the license reconciliation process.
CalculateCompliance

Type: boolean

When this field is True (the default), and a SoftwareLicense of this type also has its CalculateCompliance field set to True (the default), that license must have its consumption calculated from imported inventory. When False, the compliance state of licenses with this type must be imported or otherwise set manually, not calculated.
ReconcileAsSoftware LicenseTypeID

Type: integer. Nullable

If specified, treat this license type as if it were another for license reconciliation purposes. Foreign key to another type in this SoftwareLicenseType table.
Enabled

Type: boolean

Indicates whether this license type is enabled
CoverOnPremise

Type: boolean

If the value True, the license created for this type will have on-premise selected in the use rights.
CoverAllCloudProviders

Type: boolean

If the value True, the license created for this type will have all cloud service provider selected in the use rights. If the value is False, the specific cloud provider values could be found from SoftwareLicenseTypeCloudServiceProviderDefault table