Tables

<< Click to Display Table of Contents >>

Raynet One Data Hub > 14.0 u1 > 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