License CSV

The License object is central to software asset management. This is the database object where consumption of entitlements is recorded.

Table 1. Spreadsheet columns for License DDI

Column

Details

BusinessUnit

Type: String. Optional. Maximum: 500 (64)

The business unit of the asset: the name of the last level or some of the last levels or all levels. Level and sub-levels must be separated by the forward slash [/] character. The maximum size for each level is 64 characters.

Category

Type: String. Optional. Maximum: 500 (64)

The category of asset: the name of the last level or some of the last levels or all levels. Level and sub-levels must be separated by the forward slash [/] character. The maximum size for each level is 64 characters.

ChargesAmount

Type: Float. Optional. Maximum: -

For interdepartmental charge-backs, this is the amount to be charged for each computer on which applications linked to the license is installed.

ChargesFrequency

Type: String. Optional. Maximum: 1000

The frequency with which charge-back amounts are accounted for. The value should match a PeriodTypeDefaultValue in the PeriodType table in the compliance database. Standard values are:
  • Weekly
  • Monthly
  • Quarterly
  • Yearly
  • Lump Sum.

For single tenant on-premises implementations, new period types will be created for non-existing values. (Not supported for multi-tenant implementations for managed service providers, nor for cloud implementations.)

Comments

Type: String. Optional. Maximum: -

Comments about the license recorded by an operator. This field may also be used for storing license keys.

ComplianceStatus

Type: String. Optional. Maximum: 100

The compliance position of this license.

The value should match a StatusDefaultValue in the SoftwareLicenseComplianceStatus table in the compliance database. Standard values are:
  • Compliant
  • At Risk
  • Unknown
  • Not Tracked.

For single tenant on-premises implementations, new compliance status values will be created for non-existing values. (Not supported for multi-tenant implementations for managed service providers, nor for cloud implementations.)

ContractNo

Type: String. Optional. Maximum: 60

The contract number (foreign key) for any contract attached to this license.

CostCenter

Type: String. Optional. Maximum: 500 (64)

The cost center of the asset: the name of the last level or some of the last levels or all levels. Level and sub-levels must be separated by the forward slash [/] character. The maximum size for each level is 64 characters.

CurrencyCode

Type: String. Optional. Maximum: 32

The currency code must match an existing currency code in. See the list in Currency Codes.

CurrencyDate

Type: Date. Optional. For formats, see Entering Dates in the CSV Templates.

Date the exchange rate is valid.

CurrencyRate

Type: Float. Optional. Maximum: -

The currency exchange rate against the default currency value set in the System Defaults page.

CurrencySnapshotName

Type: String. Optional. Maximum: 256

The name of the conversion rate snapshot to be applied to currencies in this import, when converted to the default currency. This must be an exact match for an entry in the SnapshotName column of the CurrencyRateSnapshot table of the compliance database.

DocumentUNC

Type: String. Optional. Maximum: 4000

UNC path to the license contract document. At your discretion, you may use this to link to a copy of the license agreement, or to a contract (such as a purchasing agreement or a support contract) that is relevant to this license.

DocumentURL

Type: String. Optional. Maximum: 4000

URL to the license contract document. At your discretion, you may use this to link to a copy of the license agreement, or to a contract (such as a purchasing agreement or a support contract) that is relevant to this license. This field accepts a complete URL, including the protocol.

Duration

Type: String. Optional. Maximum: 100

How long entitlements conveyed by this license persist.

The value should match a DurationDefaultValue in the SoftwareLicenseDuration table in the compliance database. Standard values are:
  • Perpetual
  • TimeLimited
  • Subscription.

For single tenant on-premises implementations, new duration values will be created for non-existing values. (Not supported for multi-tenant implementations for managed service providers, nor for cloud implementations.)

Edition

Type: String. Optional. Maximum: 60

The edition of the license. Typically kept synchronized with the edition of the application whose use is authorized by the license.

ExpiryDate

Type: Date. Optional. For formats, see Entering Dates in the CSV Templates.

The date that rights conveyed by this license expire. Use this for a time-limited license, and perhaps for a subscription license if you so choose (remembering that you will need to maintain the date if the subscription is renewed). Leave this column empty for perpetual licenses.

ExtraEntitlements

Type: Integer. Optional. Maximum: -

The number of entitlements conveyed by this license, apart from the ones recorded in purchases linked to the license. This is the figure displayed in the Extra entitlements field on the Compliance tab of the license properties.

LicenseKey

Type: String. Optional. Maximum: 256

The multiple-use license key of the license. Only used when the license key type is a multi-use key (for example, an Enterprise key used to cover multiple installs).

LicenseName

Type: String. Key. Mandatory. Maximum: 256

Name of the license.
LicenseStatus

Type: String. Optional. Maximum: 100

The current status of this license in the business lifecycle.

The value should match a DefaultValue in the LicenseStatus table in the compliance database. Standard values are:
  • Active
  • Retired
  • In Stock
  • Purchased
  • Received.

For single tenant on-premises implementations, new license status values will be created for non-existing values. (Not supported for multi-tenant implementations for managed service providers, nor for cloud implementations.)

LicenseType

Type: String. Optional. Maximum: 100

The kind of license.

The value should match a TypeDefaultValue in the SoftwareLicenseType table in the compliance database. Standard values are:
  • Enterprise
  • Device
  • Node-Locked
  • User
  • Concurrent User
  • Appliance
  • Client Server
  • OEM
  • Evaluation
  • Run-Time
  • Device (Processor-Limited)
  • Site
  • Named User
  • Device (Core-Limited)
  • Core Points
  • Oracle Processor
  • Oracle Named User Plus
  • Processor Points
  • Oracle Legacy
  • Enterprise Agreement
  • SAP Named User
  • Microsoft Server Processor
  • CAL
  • Tiered Device
  • IBM Processor Value Unit
  • IBM Authorized User
  • IBM Concurrent User
  • IBM Floating User
  • Custom Metric
  • Processor
  • IBM Resource Value Unit
  • IBM User Value Unit
  • Microsoft Server Core
  • Oracle User
  • SAP Package
  • Microsoft SCCM Client Device
  • Microsoft SCCM Client User
  • Microsoft Developer Network.

For single tenant on-premises implementations, new license type values will be created for non-existing values. (Not supported for multi-tenant implementations for managed service providers, nor for cloud implementations.)

Location

Type: String. Optional. Maximum: 500 (64)

The location responsible for this license. The value can be specified as a single description level or as levels and sub-levels separated by the forward slash [/] character. The maximum size for each level is 64 characters.

OverrideUnitPrice

Type: Float. Optional. Maximum: -

The most recent cost-per-entitlement for this license. This figure is used to calculate exposure or savings when there are no purchases linked to the license. It is displayed in the Override unit price field on the Purchases tab of the license properties.

PublisherName

Type: String. Optional. Maximum: 64

The publisher who manufactures and distributes the application attached to this license. The value should match a VendorName value in the Vendor table in the compliance database. Note that the vendor record must exist in the compliance database before you import this license object.

ResalePrice

Type: Float. Optional. Maximum: -

When the license (and the associated software) has been disposed of by reselling to someone else, this field stores the price for which the software assets were sold.

ResaleRecipient

Type: String. Optional. Maximum: 128

When the license (and the associated software) has been disposed of by reselling to someone else, this field identifies the person or organization who took over the software assets.

RetirementDate

Type: Date. Optional. For formats, see Entering Dates in the CSV Templates.

The date that this license was removed from use in your enterprise. Leave this column empty for licenses that are still in use ("active").

RetirementReason

Type: String. Optional. Maximum: 100

The reason why this license was removed from active use in your enterprise.

The value should match a DefaultValue in the EndOfLifeReason table in the compliance database. Standard values are:
  • Nothing (leave this column blank)
  • Lost
  • Stolen
  • Disposed
  • Sold
  • Donated
  • Broken.

For single tenant on-premises implementations, new retirement reason values will be created for non-existing values. (Not supported for multi-tenant implementations for managed service providers, nor for cloud implementations.)

SubjectToTrueUp Type: Boolean. Optional. Default: False.

Set this field to True if the license is a true-up license (and so will never be displayed as at risk).

Version

Type: String. Optional. Key. Maximum: 60

The version of the license. While strictly speaking the version can be left blank, it forms part of a multi-part key to identify existing license records in the database for possible updates. It is therefore recommended that you provide a version in your CSV import.

2022 R1