SSIS Components for Microsoft OneDrive

Build 24.0.9062

Users

The OneDrive table Users in which an admin user can view the users details.

Users Information

Projection is done server-side. Basic select query is supported e.g.:

SELECT * FROM Users

Using this view an admin user can list all other users details.

Columns

Name Type References Description
id [KEY] String
deletedDateTime Datetime
accountEnabled Bool
businessPhones String
city String
companyName String
country String
createdDateTime Datetime
department String
displayName String
employeeHireDate Datetime
employeeId String
employeeOrgData_costCenter String
employeeOrgData_division String
employeeType String
givenName String
identities String
imAddresses String
isResourceAccount Bool
jobTitle String
lastPasswordChangeDateTime Datetime
mail String
mailNickname String
mobilePhone String
officeLocation String
onPremisesDistinguishedName String
onPremisesDomainName String
onPremisesExtensionAttributes_extensionAttribute1 String
onPremisesExtensionAttributes_extensionAttribute10 String
onPremisesExtensionAttributes_extensionAttribute11 String
onPremisesExtensionAttributes_extensionAttribute12 String
onPremisesExtensionAttributes_extensionAttribute13 String
onPremisesExtensionAttributes_extensionAttribute14 String
onPremisesExtensionAttributes_extensionAttribute15 String
onPremisesExtensionAttributes_extensionAttribute2 String
onPremisesExtensionAttributes_extensionAttribute3 String
onPremisesExtensionAttributes_extensionAttribute4 String
onPremisesExtensionAttributes_extensionAttribute5 String
onPremisesExtensionAttributes_extensionAttribute6 String
onPremisesExtensionAttributes_extensionAttribute7 String
onPremisesExtensionAttributes_extensionAttribute8 String
onPremisesExtensionAttributes_extensionAttribute9 String
onPremisesImmutableId String
onPremisesLastSyncDateTime Datetime
onPremisesProvisioningErrors String
onPremisesSamAccountName String
onPremisesSecurityIdentifier String
onPremisesSyncEnabled Bool
onPremisesUserPrincipalName String
otherMails String
postalCode String
preferredLanguage String
state String
streetAddress String
surname String
userPrincipalName String
userType String

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062