Retrieved information
This page documents the data retrieved by the Microsoft 365 connector that is stored by Snow.
Account
| Field in Microsoft 365 API | Description |
|---|---|
| AccountObjectId | Unique ID (TenantId) of the account. |
| AccountName | Name of the account. The snowpack field is populated with TenantName and parses the organization verified domains.For instance, the snowsoft.onmicrosoft.com will be populated as "snowsoft" in the AccountName field. |
| Company | The snowpack field is populated with the DisplayName of the organization details.If the field is Null, then it will get populated with the TenantName. |
| - | Name of the vendor A constant that is set by the connector. Value = "Microsoft" |
| - | Name of the service A constant that is set by the connector. Value = "Office 365" |
Account Sku
| Field in Microsoft 365 API | Description |
|---|---|
| SkuPartNumber | The SKU part number associated with the account. |
| ActiveUnits | Number of purchased licenses. |
| WarningUnits | Number of licenses that have expired. |
| ConsumedUnits | Number of licenses currently assigned to user accounts. |
Activity Exchange Online
| Field in Microsoft 365 API | Description |
|---|---|
| - | The name of the service A constant that is set by the connector. Value = "Exchange Online" |
| LastLogonTime | Last time Exchange Online was used. |
Activity Skype for Business
| Field in Microsoft 365 API | Description |
|---|---|
| - | The name of the service A constant that is set by the connector. Value = "Skype for Business" |
| LastActivityTime | Last time Skype for Business was used. |
Activity OneDrive
| Field in Microsoft 365 API | Description |
|---|---|
| - | The name of the service. A constant that is set by the connector. Value = "OneDrive" |
| LastActivityTime | Last time OneDrive was used. |
Activity SharePoint
| Field in Microsoft 365 API | Description |
|---|---|
| - | The name of the service. A constant that is set by the connector. Value = "SharePoint" |
| LastActivityTime | Last time SharePoint was used. |
Activity Yammer
| Field in Microsoft 365 API | Description |
|---|---|
| - | The name of the service. A constant that is set by the connector. Value = "Yammer" |
| LastActivityTime | Last time Yammer was used. |
Activity Teams
| Field in Microsoft 365 API | Description |
|---|---|
| - | The name of the service. A constant that is set by the connector. Value = "Teams" |
| LastActivityTime | Last time Teams was used. |
Service
| Field in Microsoft 365 API | Description |
|---|---|
| ServiceName | The name of the service. |
| ProvisioningStatus | The status of the service. |
| ServicePlanId | The Service plan id. |
| ServiceType | The type of the service. |
| TargetClass | TargetClass. |
User
| Field in Microsoft 365 API | Description |
|---|---|
| DisplayName | Display name of the user. |
| UserPrincipalName | User ID of the user. |
| OverallProvisioningStatus | Whether or not the user has been provisioned for their services. |
| BlockCredential | Whether or not the user is prevented from signing in. |
| SignInName | Sign in name of the user. |
| ValidationStatus | Whether or not the user has any errors. |
| FirstName | First name of the user. |
| LastName | Last name of the user. |
| ImmutableId | Only returned for federated users. |
| IsLicensed | Whether or not the user has any licenses assigned. |
| LastDirSyncTime | Date and time of the last directory synchronization. (only returned from users synced with Azure Active Directory through Active Directory synchronization) |
| LastPasswordChangeTimestamp | The most recent time at which a password change for the user was registered in Azure Active Directory. |
| LiveID | Unique login ID of the user. |
| WhenCreated | Date and time for when the user was created. |
| ObjectId | Unique ID of the user. |
| UserType | Type of the user. |
| Country | The country/region in which the user is located. |
| Department | The name for the department in which the user works. |
User License
| Field in Microsoft 365 API | Description |
|---|---|
| SkuPartNumber | The SKU associated with the user license. |