Skip to main content

Imports of license data: Reference

Refer to the table below for a detailed description on the required data when you want to import new license purchases or update existing licenses with new metadata in SAM on Snow Atlas. For more information on how to import data, see Manage imports of license data

To perform a successful import, the following information must be provided:

  • Application name, Application part number, or SKU (stock keeping unit)
    Select your preferred identifier under Identity mapping in the Import settings step of the import wizard.

  • Legal organization

  • Purchase date

Information indicated as “Required to get complete status” must be provided, otherwise the license purchase will be indicated as incomplete. An incomplete license purchase will not be included in the compliance calculations.

Field name in the import viewData typeRequiredDescriptionExample
License IDNumberNoThe ID of an existing license.
To check the License ID:
  1. List all licenses.
  2. Open Column selector and add the License ID column to the list.
  3. Find the license to update from and the corresponding License ID.
Note: For license updates, the License ID field is required. If it is not provided, the licenses in the import file will be treated as new licenses.
486
Application nameTextYesThe name of an existing application.Adobe Photoshop CS4
SKU (stock keeping unit)TextYesThe SKU number of an existing application.

Note: For SKU numbers that are not in the database, the license purchase will be imported as incomplete (with the ALLOW_INCOMPLETE_LICENSES setting enabled).
SFKJHDF34
Legal organisationTextYesThe legal organization that made the purchase.
Delimiter between organization IDs is dependent on setting.
Required to get complete status.

If the import is unable to map to the organization, find the identities for each organization node and add the identities to the import file. To find the Organization ID, also called GUID do the following:
  • In the report Organizational overview, add the column Organization ID. For more information, see Add columns to lists.
  • Example of Organization Name: ROOT,IT
  • Example of Organization ID (GUID): 5d0ed580-e3e9-4377-a944-9845e8fd6e54
Purchase dateDateYesThe date of the purchase.
Required to get complete status.
Supported date formats:
  • dd/MM/yyyy
  • MM/dd/yyyy
  • dd-MM-yyyy
  • yyyy/MM/dd
  • yyyy-MM-dd
2025-10‐28
MetricTextNoThe unit of measurement for the license.
Required to get complete status.
An empty value in this field will mark the license purchase as incomplete.
Allowed values are:
  • Installations or Installation
  • Total users or Users
  • Total cores or Number of processor cores
  • Total processors or Number of processors
  • CAL (Client Access license), CAL or Client Access license
  • Total devices or Devices
  • Concurrent Users
  • Concurrent Devices
  • Processor Value Units or PVU
  • Custom Compare Value, Custom or Custom compare values
USERS
Assignment typeTextYesProvides information on how a certain license purchase assigns licenses to relevant consumers.
Available values are:
  • Organisation or Organization
  • Computer/datacenter, Computer or Datacenter
  • User or Users
  • Site
Organization
Is upgradeBooleanNoDefines if the license is an upgrade license or not.
Allowed values are:
  • YES, 1, or True
  • NO, 0, or False
Note: The license purchase must be connected to an already existing base license, or it will be imported as an incomplete license (with the ALLOW_INCOMPLETE_LICENSES setting enabled).
YES
Upgrade from license IDNumberNoThe ID of the license to upgrade from.
Required to get complete status if Is upgrade is set to YES.
To check the ID:
  1. List all licenses.
  2. Open Column selector and add the ID column to the list.
  3. Find the license to upgrade from and the corresponding ID.
242
Base license quantity to upgradeNumberNoThe number of base licenses to upgrade.50
QuantityNumberNoThe number of licenses.
Required to get complete status.
If used for an upgrade license, this number should reflect the quantity that you are entitled to convert.

Example: For metrics Number of processors and Number of processor cores, the Quantity refers to the number of licensed processors/processor cores.
50
Subscription valid fromDateNoStart date of the subscription period.
Required to get complete status if Is subscription is set to YES.
Supported date formats:
  • dd/MM/yyyy
  • MM/dd/yyyy
  • dd-MM-yyyy
  • yyyy/MM/dd
  • yyyy-MM-dd
2025-01-01
Subscription valid toDateNoEnd date of the subscription period.
Required to get complete status if Is subscription is set to YES.
Supported date formats:
  • dd/MM/yyyy
  • MM/dd/yyyy
  • dd-MM-yyyy
  • yyyy/MM/dd
  • yyyy-MM-dd
2026-12-31
Is subscriptionBooleanNoDefines if it is a subscription license:
  • YES, 1, or true
  • NO, 0, or false
If set to YES, Subscription valid from and Subscription valid to must also be defined.
Purchase priceNumberNoThe value of the license purchase.100
Purchase currencyTextNoThe currency of the license purchase.EUR
Cross edition rightsBooleanNoThe right to use the same and/or lower editions of the product.
Allowed values are:
  • YES, 1, or true
  • NO, 0, or false
Note: Should only be enabled if the license is purchased with downgrade rights.
YES
Downgrade rightsBooleanNoThe right to use the lower product version of the product.
Allowed values are:
  • YES, 1, or true
  • NO, 0, or false
YES
Auto allocate (distribute) licenseBooleanNoActivates auto allocation.
Allowed values are:
  • YES, 1, or true
  • NO, 0, or false
NO
Maintenance includes upgrade rightsBooleanNoThe license includes a support or maintenance agreement. The field defines whether or not a maintenance agreement includes upgrade rights.
Allowed values are:
  • YES, 1, or true
  • NO, 0, or false
Should be set to YES if the license is purchased with upgrade rights.
Should be set to NO if the license is purchased without upgrade rights.

Note: The Maintenance and Support fields should only be used if:
  • The license has upgrade rights within a time frame, either by an agreement or by user-specified dates.
  • The license includes a support or maintenance agreement.
Note: If you update an existing license and include any of the Maintenance and Support fields in the license import, be aware that any previously entered data in the Maintenance and Support fields will be deleted from the database.
YES
Maintenance according to agreementBooleanNoDefines whether or not automatic upgrade will use agreement period.
Allowed values are:
  • YES, 1, or true
  • NO, 0, or false
If set to NO and Maintenance includes Upgrade Rights is activated, an automatic upgrade period must be provided (in Maintenance and support valid from and Maintenance and support valid to), otherwise the license will be invalid.

Note: The Maintenance and Support fields should only be used if:
  • The license has upgrade rights within a time frame, either by an agreement or by user-specified dates.
  • The license includes a support or maintenance agreement.
Note: If you update an existing license and include any of the Maintenance and Support fields in the license import, be aware that any previously entered data in the Maintenance and Support fields will be deleted from the database.
NO
Maintenance and support valid fromDateNoDefines what date automatic upgrade is valid from.
Required for the license to be complete if Automatic upgrade is activated, and Maintenance according to agreement is set to NO.
Supported date formats:
  • dd/MM/yyyy
  • MM/dd/yyyy
  • dd-MM-yyyy
  • yyyy/MM/dd
  • yyyy-MM-dd
Note: The Maintenance and Support fields should only be used if:
  • The license has upgrade rights within a time frame, either by an agreement or by user-specified dates.
  • The license includes a support or maintenance agreement.
Note: If you update an existing license and include any of the Maintenance and Support fields in the license import, be aware that any previously entered data in the Maintenance and Support fields will be deleted from the database.
2025-10‐28
Maintenance and support valid toDateNoDefines what date automatic upgrade is valid to.
Required for the license to be complete if Automatic upgrade is activated, and Maintenance according to agreement is set to NO.
Supported date formats:
  • dd/MM/yyyy
  • MM/dd/yyyy
  • dd-MM-yyyy
  • yyyy/MM/dd
  • yyyy-MM-dd
Note: The Maintenance and Support fields should only be used if:
  • The license has upgrade rights within a time frame, either by an agreement or by user-specified dates.
  • The license includes a support or maintenance agreement.
Note: If you update an existing license and include any of the Maintenance and Support fields in the license import, be aware that any previously entered data in the Maintenance and Support fields will be deleted from the database.
2026‐08‐31
Agreement numberTextNoAn external agreement number.
This field can be left empty if Maintenance according to agreement is set to NO. If used, this agreement must already exist.

Note: The agreement needs to exist prior to the license import. Also, the purchase date of the license must be within the agreement period.
HP19289182
External IDTextNoUsed to assign an ID from an external system, such as ERP, CRM or sales/order systems.ABC123
Vendor/resellerTextNoThe name of the vendor/reseller that this license was purchased from.Amazon
License proof locationTextNoThe location where proof of license purchase is stored.Safe at the office
Purchase notesTextNoInformation specific to the license purchase, as free text.
Serial numbers/ license keysTextNoThe serial numbers/license keys received for this purchase.
Installation media locationTextNoThe location where the installation media is stored.File server 1
Purchase invoice referenceTextNoThe reference number found on the invoice.ADB00889912
Product descriptionTextNoUse the Product description to add either an own product description or the manufacturer's.OfficeStd 2010 SNGL MVL
Maintenance costNumberNoThe maintenance cost per period.100
Support costNumberNoThe support cost per period.100
Maintenance and support notesTextNoNotes on the maintenance and support.
Maintenance and support invoiceTextNoThe reference to the maintenance and support invoice.SHB00375297
[Custom fields]NoImport of data to existing license custom fields.
Supported custom field data types are:
  • Text
  • Date
  • Yes|No
  • Digit
  • Currency
  • Decimal