License

A software license. License types include perpetual, subscription, renewal, upgrade, maintenance etc. E.g. Visual Studio Enterprise Sub MSDN, Azure Active Directory Premium P2

General Attributes

Name	Type	Description
Product Family	String	Product family Edit User Role Required: SAM User Sample Values: Microsoft 365 Microsoft
License Name	String	The name of the licensed product Edit User Role Required: SAM User Sample Values: Office Visio (Plan 2) Office 365 E5 Power BI Pro
License User Activity	String	Link to report including license usage details
Product Description	String	The product description Edit User Role Required: SAM User Sample Values: Service Names: EXCHANGE_S_FOUNDATION,Microsoft Stream
Product Version	String	The product version Edit User Role Required: SAM User Sample Values: 2016 2019
Product Edition	String	Product Edition Edit User Role Required: SAM User Sample Values: Professional Professional Plus
License Start Date	Date	The date when the license/subscription starts Edit User Role Required: SAM User
License End Date	Date	The date when the license/subscription ends Edit User Role Required: SAM User
License Lifetime	Enum	Lifetime of License (Expired, 0-30 days, 31-90 days, 90+ days) Enum Values Unspecified Expired Under 30 Days 30-90 Days Over 90 Days
License Status Summary	Enum	High level status of License (Excluded/Expired/Warning/Active) Enum Values Unspecified Excluded Expired Warning Active
Quantity	Number	The number of licenses Edit User Role Required: SAM User
Quantity Consumed	Number	The number of licenses consumed Edit User Role Required: SAM User
Quantity Available	Number	The number of licenses available
Purchase Price	Number	The purchase price for the license Edit User Role Required: SAM User
Currency	Enum	The purchase currency Edit User Role Required: SAM User Enum Values Unknown United States Dollar – USD Euro – EUR British Pound – GBP Australian Dollar – AUD Canadian Dollar – CAD Chinese Renminbi Yuan Offshore – CNH Chinese Renminbi Yuan – CNY Colombian Peso – COP Japanese Yen – JPY Malaysian Ringgit – MYR Mexican Peso – MXN Norwegian Krone – NOK South African Rand – ZAR Swedish Krona – SEK
Purchase Date	Date	Purchase Date Edit User Role Required: SAM User
Invoice Number	String	Invoice Number Edit User Role Required: SAM User
Order Number	String	Order Number Edit User Role Required: SAM User
Internal Reference	String	Internal Reference Edit User Role Required: SAM User
Cost Centre	String	Cost Centre Edit User Role Required: SAM User
Owner	String	License owner Edit User Role Required: SAM User
Office	String	Office Edit User Role Required: SAM User
Business Unit	String	Business Unit Edit User Role Required: SAM User
Discipline	String	Discipline e.g. IT, Marketting, Sales, All Disciplines Edit User Role Required: SAM User
Cloud Based License	Boolean	Cloud Based License – true, false or not set Edit User Role Required: SAM User Enum Values False True
Geographically Restricted	Boolean	Geographically Restricted – true, false or not set Edit User Role Required: SAM User Enum Values False True
Notes	String	Sam360 notes associated with the license Edit User Role Required: SAM User
Country On Agreement	String	The country name on the license aggrement Edit User Role Required: SAM User
Country Of Usage	String	Country Of Usage Edit User Role Required: SAM User
Part Number	String	Part Number Edit User Role Required: SAM User Sample Values: VISIOCLIENT ENTERPRISEPREMIUM POWER_BI_PRO
License Source	Enum	License Source Edit User Role Required: SAM User Enum Values Unknown Portal Import VLSC Cloud
License Type	Enum	License Type – User/Device/Processor/Site etc. Edit User Role Required: SAM User Enum Values Unspecified User Device Named Device User CAL Device CAL Processor Core Site Concurrent Device Concurrent User Server And CAL User Access Device Access Host MSDN Windows Client Active SA VDA SQL Technology SQL Passive Node Office 365 Server CAL Royalty Free User VDA Device VDA
Transaction Type	Enum	Transaction Type Edit User Role Required: SAM User Enum Values Unknown Perpetual Upgrade Subscription Software Assurance Perpetual And SA Upgrade And SA Subscription And SA Perpetual And Subscription And SA Maintenance Perpetual And Maintenance
License Program	Enum	The license program Edit User Role Required: SAM User Enum Values Unknown OEM FPP ISV IUR Open Open Value Open Value Subscription MPSA Select Select Plus EA EAS SCE CSP Store Standard Other
License Agreement Type	Enum	License Agreement Type Edit User Role Required: SAM User Enum Values Unknown Standard Training Testing Corporate Government Education
Comments	String	Comments Edit User Role Required: SAM User
License Note	File	License Note (Markdown Format)

License Allocation Attributes

Name	Type	Description
Product Version (Override)	String	The product version (Override) Edit User Role Required: SAM User
Exclude From License Position	Boolean	Exclude this license from license position calculation Edit User Role Required: SAM User Enum Values False True
Pack Size (Interpreted)	Number	How many licenses included in license pack
Expired	Boolean	Has this license/subscription expired? Enum Values False True
Product Version (Interpreted)	String	The product version used for license calculation
License Type (Interpreted)	Enum	The license type used for license calculation – User/Device/Processor/Site etc. Enum Values Unspecified User Device Named Device User CAL Device CAL Processor Core Site Concurrent Device Concurrent User Server And CAL User Access Device Access Host MSDN Windows Client Active SA VDA SQL Technology SQL Passive Node Office 365 Server CAL Royalty Free User VDA Device VDA
License Program (Interpreted)	Enum	The license program option used for license calculation Enum Values Unknown OEM FPP ISV IUR Open Open Value Open Value Subscription MPSA Select Select Plus EA EAS SCE CSP Store Standard Other
License Transaction Type (Interpreted)	Enum	The license transaction type used for license calculation Enum Values Unknown Perpetual Upgrade Subscription Software Assurance Perpetual And SA Upgrade And SA Subscription And SA Perpetual And Subscription And SA Maintenance Perpetual And Maintenance
License Entitlement Calculation Note	String	License Entitlement Calculation Note
Ignore Calculation Warning	Boolean	Ignore License Entitlement Calculation Warning Edit User Role Required: SAM User Enum Values False True
License Assignment Group ID	Number	License Assignment Group ID
Unassigned License Cost	Number	Unassigned License Cost Sample Values: 109.2 168.5 3315
Assigned Cost	Number	Assigned Cost Sample Values: 1729.6 6006 12143.45
Date Created	Date	Date the license was created in the portal or imported
Import Reference	String	Original filename of imported licenses

License Renewal Attributes

Name	Type	Description
Renewal Reminder Days	Enum	Should this license/subscription be included in upcoming license renewal reports? (Only works if ‘License End Date’ is set) Edit User Role Required: SAM User Enum Values 1 Day 1 Week 2 Weeks 1 Month 2 Months 3 Months 4 Months 5 Months 6 Months
Renewal Reminder Date	Date	Date on which this license will be included in license renewal reports. (Only works if ‘License End Date’ and ‘Renewal Reminder Days’ are set)
Renewal Status	Enum	Has a license/subscription renewal been approved? Options: Renewal Not Due Yet, Approval Required, Approval Rejected, Approved, Renewed Edit User Role Required: SAM User Enum Values Unspecified Renewal Not Due Yet Approval Required Approval Rejected Approved Renewed
Renewal Approval Details	String	Renewal Approval Details Edit User Role Required: SAM User

Custom Details

Name	Type	Description
Custom Field 1	String	Custom Field 1 Edit User Role Required: SAM User
Custom Field 2	String	Custom Field 2 Edit User Role Required: SAM User
Custom Field 3	String	Custom Field 3 Edit User Role Required: SAM User
Custom Field 4	String	Custom Field 4 Edit User Role Required: SAM User
Custom Field 5	String	Custom Field 5 Edit User Role Required: SAM User

Actions

Name	Description	Role Required
Add New License	–	Tenant Administrator
Delete Licenses	–	Tenant Administrator

Rate This Article :

Updated on August 16, 2022

Introduction

Portal

Data Collection

Data Model