Attribute mapping for Microsoft 365 Inventory
Summary
This article contains attribute mapping for the Microsoft 365 Inventory extension. It lists all attributes that are imported or updated by the data provider for subscriptions managed as licenses in the system and subscribers. Subscribers are imported as a multi fragment of the license object.
The SaaS Import package is installed as part of the extension mentioned above. It contains the import definitions used for creating and updating subscribers and subscriptions.
Information is cached in MyWorkspace on a daily basis (Midnight CET/CEST).
Any changes in the provider's administration portal that occur after the first import on a particular day will only be imported with an import on a following day.
Subscriptions
Matching keys: LCMCloudSubscriptionClassBase.SourceID
Insert import definition
| Source Attribute/Transformation | Target Data Definition | Target Attribute | Note |
|---|---|---|---|
| Id | LCMCloudSubscriptionClassBase | SourceID | Key for Import |
| SkuId | LCMCloudSubscriptionClassBase | SKU_Id | |
| SkuPartNumber | LCMCloudSubscriptionClassBase | PID | |
| SkuPartNumber | SPSAssetClassBase | Name | |
| SkuPartNumber | SPSAssetClassOrder | ManufacturerOrderNumber | |
| Execution date of data provider | SPSAssetClassLicenseMaintenance | ValidFrom | |
| "40" (literal value) | SPSAssetClassLicense | Type | Relation: value |
| Tenant from configuration | LCMCloudSubscriptionClassBase | Office365TenantId | |
| OU from data provider configuration | SPSCommonClassBase | OU | Relation: Production.ID |
| Execution date of data provider | SPSCommonClassBase | ValidFrom | |
| 'Software as a Service (SaaS)' | SPSAssetClassOrder | OrderNumber |
Update import definition
| Source Attribute/Transformation | Target Data Definition | Target Attribute | Note |
|---|---|---|---|
| CapabilityStatus | LCMCloudSubscriptionClassBase | CapabilityStatus | Relation: CloudStatus |
| ConsumedUnits | LCMCloudSubscriptionClassBase | ConsumedUnits | |
| Id | LCMCloudSubscriptionClassBase | SourceID | Key for Import |
| PrepaidEnabledUnits | SPSAssetClassLicense | PurchasedCount | |
| PrepaidEnabledUnits | LCMCloudSubscriptionClassBase | PrepaidEnabledUnits | |
| PrepaidSuspendedUnits | LCMCloudSubscriptionClassBase | PrepaidSuspendedUnits | |
| PrepaidWarningUnits | LCMCloudSubscriptionClassBase | PrepaidWarningUnits | |
| SkuId | LCMCloudSubscriptionClassBase | SKU_Id | |
| SkuPartNumber | LCMCloudSubscriptionClassBase | PID | |
| SkuPartNumber | SPSAssetClassOrder | ManufacturerOrderNumber | |
| "0" (literal value) | SPSAssetClassLicense | PurchasedCountInfinite | |
| Execution date of data provider | LCMCloudSubscriptionClassBase | ChangedDate | |
| "1" | LCMCloudSubscriptionClassBase | AppliesToUser |
Subscribers
Matching keys: LCMCloudSubscriptionClassBase.SourceID AND LCMCloudSubscriptionClassAccount.UserPrincipalName
For the detailed explanation on how subscribers are matched, please refer to Assignment of imported subscribers.
| Source Attribute/Transformation | Target Data Definition | Target Attribute | Note |
|---|---|---|---|
| MailAddress | LCMCloudSubscriptionClassAccount | MailAddress | |
| SubscriptionId | LCMCloudSubscriptionClassBase | SourceID | ID of the subscription. Key for import |
| UserPrincipalName | LCMCloudSubscriptionClassAccount | UserPrincipalName | Key for import |
| Execution date of data provider | LCMCloudSubscriptionClassAccount | LastSyncDate |
A subscriber is marked as "isActive = true" as long as being assigned to the subscription. When the user account is not subscribed anymore, the subscriber's record is deleted unless there exists a license requirement record. In this case, the account is market as "isActive = false". Background processing of license management will remove the account as soon as the minimum entitlement period has expired.
Technical details
Access to Microsoft 365 admin data is implemented using Microsoft's Graph API v1.0. For more details, refer to Overview of Microsoft Graph.