<< 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 •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 |