Tables

<< Click to Display Table of Contents >>

Raynet One Data Hub > 14.0 > Connectors > Alphabetic Connector List > Microsoft 365 > Extracted Data 

Tables

Table

Column

Type

users

•deletedDateTime

•displayName

•employeeId

•givenName

•id

•mail

•onPremisesUserPrincipalName

•surname

•tenantId

•userPrincipalName

•userType

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

assigned_licenses_for_users

•skuId

•userId

•String

•String

assigned_plans_for_users

•assignedDateTime

•capabilityStatus

•service

•servicePlanId

•userId

•String

•String

•String

•String

•String

user_activity

•deletedDate

•displayName

•exchangeLastActivityDate

•exchangeLicenseAssignDate

•hasExchangeLicense

•hasOneDriveLicense

•hasSharePointLicense

•hasSkypeForBusinessLicense

•hasTeamsLicense

•hasYammerLicense

•isDeleted

•oneDriveLastActivityDate

•oneDriveLicenseAssignDate

•reportRefreshDate

•sharePointLastActivityDate

•sharePointLicenseAssignDate

•skypeForBusinessLastActivityDate

•skypeForBusinessLicenseAssignDate

•teamsLastActivityDate

•teamsLicenseAssignDate

•userPrincipalName

•yammerLastActivityDate

•yammerLicenseAssignDate

•String

•String

•String

•String

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

assigned_products_for_user_activity

•assignedProduct

•userPrincipalName

•String

•String

activations_user_detail

•displayName

•reportRefreshDate

•userPrincipalName

•String

•String

•String

user_activation_counts_for_activations_user_detail

•activatedOnSharedComputer

•android

•ios

•lastActviatedDate

•mac

•productType

•userPrincipalName

•windows

•windows10Mobile

•Boolean

•Integer

•Integer

•String

•Integer

•String

•String

•Integer

•Integer

subscribed_skus

•appliesTo

•capabilityStatus

•consumedUnits

•id

•skuId

•skuPartNumber

•String

•String

•String

•String

•String

•String

prepaid_units_for_subscribed_skus

•enabled

•subscribedSkuId

•suspended

•warning

•Integer

•String

•Integer

•Integer

service_plans_for_subscribed_skus

•appliesTo

•provisioningStatus

•servicePlanId

•servicePlanName

•subscribedSkuId

•String

•String

•String

•String

•String

sign_ins

•appDisplayName

•appId

•createdDateTime

•userDisplayName

•userId

•userPrincipalName

•String

•String

•String

•String

•String

•String

app_usage

•lastActivationDate

•lastActivityDate

•reportRefreshDate

•userPrincipalName

•String

•String

•String

•String

app_usage_details

•excel

•excelMac

•excelMobile

•excelWeb

•excelWindows

•mac

•mobile

•oneNote

•oneNoteMac

•oneNoteMobile

•oneNoteWeb

•oneNoteWindows

•outlook

•outlookMac

•outlookMobile

•outlookWeb

•outlookWindows

•powerPoint

•powerPointMac

•powerPointMobile

•powerPointWeb

•powerPointWindows

•reportPeriod

•teams

•teamsMac

•teamsMobile

•teamsWeb

•teamsWindows

•userPrincipalName

•web

•windows

•word

•wordMac

•wordMobile

•wordWeb

•wordWindows

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Integer

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•String

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

•Boolean

pstn

•callId

•callType

•charge

•conferenceId

•connectionCharge

•currency

•duration

•endDateTime

•id

•inventoryType

•licenseCapability

•startDateTime

•tenantCountryCode

•usageCountryCode

•userId

•String

•String

•Integer

•String

•Integer

•String

•Integer

•String

•String

•String

•String

•String

•String

•String

•String

onedrive_usage

•activeFileCount

•fileCount

•isDeleted

•lastActivityDate

•ownerDisplayName

•ownerPrincipalName

•reportPeriod

•reportRereshDate

•siteURL

•storageAllocatedInBytes

•storageUsedInBytes

•Integer

•Integer

•Boolean

•String

•String

•String

•String

•String

•String

•Integer

•Integer

additional_user_fields

 

 

exchange_usage

•createdDate

•deletedDate

•deletedItemCount

•deletedItemQuota

•deletedItemSizeInBytes

•displayName

•hasArchive

•isDeleted

•issueWarningQuotaInBytes

•itemCount

•lastActivityDate

•prohibitSendQuotaInBytes

•prohibitSendReceiveQuotaInBytes

•reportPeriod

•reportRefreshDate

•storageUsedInBytes

•userPrincipalName

•String

•String

•Integer

•Integer

•Integer

•String

•Boolean

•Boolean

•Integer

•Integer

•String

•Integer

•Integer

•String

•String

•Integer

•String

sharepoint_usage

•deletedDate

•isDeleted

•lastActivityDate

•reportPeriod

•reportRefreshDate

•sharedExternallyFileCount

•sharedInternallyFileCount

•syncedFilecount

•userPrincipalName

•viewedOrEditedFileCount

•vistedPageCount

•String

•Boolean

•String

•String

•String

•Integer

•Integer

•Integer

•String

•Integer

•Integer

sharepoint_product

•sharepointProduct

•userPrincipalName

•String

•String