SSIS Components for OneDrive

Build 20.0.7656

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 The id column for the table Users.
Etag String The Etag column for the table Users.
createdByUserId String The createdByUserId column for the table Users.
createdByUserDisplayName String The createdByUserDisplayName column for the table Users.
lastModifiedByUserId String The lastModifiedByUserId column for the table Users.
lastModifiedByUserDisplayName String The lastModifiedByUserDisplayName column for the table Users.
deletedDateTime Datetime The deletedDateTime column for the table Users.
createdByUserId String The createdByUserId column for the table Users.
createdByUserDisplayName String The createdByUserDisplayName column for the table Users.
lastModifiedByUserId String The lastModifiedByUserId column for the table Users.
lastModifiedByUserDisplayName String The lastModifiedByUserDisplayName column for the table Users.
aboutMe String The aboutMe column for the table Users.
accountEnabled Bool The accountEnabled column for the table Users.
ageGroup String The ageGroup column for the table Users.
assignedLicenses String The assignedLicenses column for the table Users.
assignedPlans String The assignedPlans column for the table Users.
birthday Datetime The birthday column for the table Users.
businessPhones String The businessPhones column for the table Users.
city String The city column for the table Users.
companyName String The companyName column for the table Users.
consentProvidedForMinor String The consentProvidedForMinor column for the table Users.
country String The country column for the table Users.
creationType String The creationType column for the table Users.
department String The department column for the table Users.
deviceEnrollmentLimit Int The deviceEnrollmentLimit column for the table Users.
displayName String The displayName column for the table Users.
employeeId String The employeeId column for the table Users.
externalUserState String The externalUserState column for the table Users.
externalUserStateChangeDateTime Datetime The externalUserStateChangeDateTime column for the table Users.
faxNumber String The faxNumber column for the table Users.
givenName String The givenName column for the table Users.
hireDate Datetime The hireDate column for the table Users.
identities String The identities column for the table Users.
imAddresses String The imAddresses column for the table Users.
interests String The interests column for the table Users.
isResourceAccount Bool The isResourceAccount column for the table Users.
jobTitle String The jobTitle column for the table Users.
lastPasswordChangeDateTime Datetime The lastPasswordChangeDateTime column for the table Users.
legalAgeGroupClassification String The legalAgeGroupClassification column for the table Users.
licenseAssignmentStates String The licenseAssignmentStates column for the table Users.
mail String The mail column for the table Users.
mailboxSettingsAutomaticRepliesSettingStatus String The mailboxSettingsAutomaticRepliesSettingStatus column for the table Users.
mailboxSettingsAutomaticRepliesSettingExternalAudience String The mailboxSettingsAutomaticRepliesSettingExternalAudience column for the table Users.
mailboxSettingsAutomaticRepliesSettingScheduledStartDateTimeDateTime Datetime The mailboxSettingsAutomaticRepliesSettingScheduledStartDateTimeDateTime column for the table Users.
mailboxSettingsAutomaticRepliesSettingScheduledStartDateTimeTimeZone String The mailboxSettingsAutomaticRepliesSettingScheduledStartDateTimeTimeZone column for the table Users.
mailboxSettingsAutomaticRepliesSettingInternalReplyMessage String The mailboxSettingsAutomaticRepliesSettingInternalReplyMessage column for the table Users.
mailboxSettingsAutomaticRepliesSettingExternalReplyMessage String The mailboxSettingsAutomaticRepliesSettingExternalReplyMessage column for the table Users.
mailboxSettingsArchiveFolder String The mailboxSettingsArchiveFolder column for the table Users.
mailboxSettingsTimeZone String The mailboxSettingsTimeZone column for the table Users.
mailboxSettingsLanguageLocale String The mailboxSettingsLanguageLocale column for the table Users.
mailboxSettingsLanguageDisplayName String The mailboxSettingsLanguageDisplayName column for the table Users.
mailboxSettingsDelegateMeetingMessageDeliveryOptions String The mailboxSettingsDelegateMeetingMessageDeliveryOptions column for the table Users.
mailboxSettingsWorkingHoursDaysOfWeek String The mailboxSettingsWorkingHoursDaysOfWeek column for the table Users.
mailboxSettingsWorkingHoursStartTime Time The mailboxSettingsWorkingHoursStartTime column for the table Users.
mailboxSettingsWorkingHoursEndTime Time The mailboxSettingsWorkingHoursEndTime column for the table Users.
mailboxSettingsWorkingHoursTimeZoneName String The mailboxSettingsWorkingHoursTimeZoneName column for the table Users.
mailboxSettingsDateFormat String The mailboxSettingsDateFormat column for the table Users.
mailboxSettingsTimeFormat String The mailboxSettingsTimeFormat column for the table Users.
mailNickname String The mailNickname column for the table Users.
mobilePhone String The mobilePhone column for the table Users.
mySite String The mySite column for the table Users.
officeLocation String The officeLocation column for the table Users.
onPremisesDistinguishedName String The onPremisesDistinguishedName column for the table Users.
onPremisesDomainName String The onPremisesDomainName column for the table Users.
onPremisesExtensionAttributesExtensionAttribute1 String The onPremisesExtensionAttributesExtensionAttribute1 column for the table Users.
onPremisesExtensionAttributesExtensionAttribute2 String The onPremisesExtensionAttributesExtensionAttribute2 column for the table Users.
onPremisesExtensionAttributesExtensionAttribute3 String The onPremisesExtensionAttributesExtensionAttribute3 column for the table Users.
onPremisesExtensionAttributesExtensionAttribute4 String The onPremisesExtensionAttributesExtensionAttribute4 column for the table Users.
onPremisesExtensionAttributesExtensionAttribute5 String The onPremisesExtensionAttributesExtensionAttribute5 column for the table Users.
onPremisesExtensionAttributesExtensionAttribute6 String The onPremisesExtensionAttributesExtensionAttribute6 column for the table Users.
onPremisesExtensionAttributesExtensionAttribute7 String The onPremisesExtensionAttributesExtensionAttribute7 column for the table Users.
onPremisesExtensionAttributesExtensionAttribute8 String The onPremisesExtensionAttributesExtensionAttribute8 column for the table Users.
onPremisesExtensionAttributesExtensionAttribute9 String The onPremisesExtensionAttributesExtensionAttribute9 column for the table Users.
onPremisesExtensionAttributesExtensionAttribute10 String The onPremisesExtensionAttributesExtensionAttribute10 column for the table Users.
onPremisesExtensionAttributesExtensionAttribute11 String The onPremisesExtensionAttributesExtensionAttribute11 column for the table Users.
onPremisesExtensionAttributesExtensionAttribute12 String The onPremisesExtensionAttributesExtensionAttribute12 column for the table Users.
onPremisesExtensionAttributesExtensionAttribute13 String The onPremisesExtensionAttributesExtensionAttribute13 column for the table Users.
onPremisesExtensionAttributesExtensionAttribute14 String The onPremisesExtensionAttributesExtensionAttribute14 column for the table Users.
onPremisesExtensionAttributesExtensionAttribute15 String The onPremisesExtensionAttributesExtensionAttribute15 column for the table Users.
onPremisesImmutableId String The onPremisesImmutableId column for the table Users.
onPremisesLastSyncDateTime Datetime The onPremisesLastSyncDateTime column for the table Users.
onPremisesProvisioningErrors String The onPremisesProvisioningErrors column for the table Users.
onPremisesSamAccountName String The onPremisesSamAccountName column for the table Users.
onPremisesSecurityIdentifier String The onPremisesSecurityIdentifier column for the table Users.
onPremisesSyncEnabled Bool The onPremisesSyncEnabled column for the table Users.
onPremisesUserPrincipalName String The onPremisesUserPrincipalName column for the table Users.
otherMails String The otherMails column for the table Users.
passwordPolicies String The passwordPolicies column for the table Users.
passwordProfilePassword String The passwordProfilePassword column for the table Users.
passwordProfileForceChangePasswordNextSignIn Bool The passwordProfileForceChangePasswordNextSignIn column for the table Users.
passwordProfileForceChangePasswordNextSignInWithMfa Bool The passwordProfileForceChangePasswordNextSignInWithMfa column for the table Users.
pastProjects String The pastProjects column for the table Users.
postalCode String The postalCode column for the table Users.
preferredLanguage String The preferredLanguage column for the table Users.
preferredName String The preferredName column for the table Users.
provisionedPlans String The provisionedPlans column for the table Users.
proxyAddresses String The proxyAddresses column for the table Users.
responsibilities String The responsibilities column for the table Users.
schools String The schools column for the table Users.
showInAddressList Bool The showInAddressList column for the table Users.
signInSessionsValidFromDateTime Datetime The signInSessionsValidFromDateTime column for the table Users.
skills String The skills column for the table Users.
state String The state column for the table Users.
streetAddress String The streetAddress column for the table Users.
surname String The surname column for the table Users.
usageLocation String The usageLocation column for the table Users.
userPrincipalName String The userPrincipalName column for the table Users.
userType String The userType column for the table Users.
Linkedactivities String The Linkedactivities column for the table Users.
LinkedappRoleAssignments String The LinkedappRoleAssignments column for the table Users.
Linkedcalendar String The Linkedcalendar column for the table Users.
LinkedcalendarGroups String The LinkedcalendarGroups column for the table Users.
Linkedcalendars String The Linkedcalendars column for the table Users.
LinkedcalendarView String The LinkedcalendarView column for the table Users.
LinkedcontactFolders String The LinkedcontactFolders column for the table Users.
Linkedcontacts String The Linkedcontacts column for the table Users.
LinkedcreatedObjects String The LinkedcreatedObjects column for the table Users.
LinkeddeviceManagementTroubleshootingEvents String The LinkeddeviceManagementTroubleshootingEvents column for the table Users.
LinkeddirectReports String The LinkeddirectReports column for the table Users.
Linkeddrive String The Linkeddrive column for the table Users.
Linkeddrives String The Linkeddrives column for the table Users.
Linkedevents String The Linkedevents column for the table Users.
Linkedextensions String The Linkedextensions column for the table Users.
LinkedfollowedSites String The LinkedfollowedSites column for the table Users.
LinkedinferenceClassification String The LinkedinferenceClassification column for the table Users.
Linkedinsights String The Linkedinsights column for the table Users.
LinkedjoinedTeams String The LinkedjoinedTeams column for the table Users.
LinkedlicenseDetails String The LinkedlicenseDetails column for the table Users.
LinkedmailFolders String The LinkedmailFolders column for the table Users.
LinkedmanagedAppRegistrations String The LinkedmanagedAppRegistrations column for the table Users.
LinkedmanagedDevices String The LinkedmanagedDevices column for the table Users.
Linkedmanager String The Linkedmanager column for the table Users.
LinkedmemberOf String The LinkedmemberOf column for the table Users.
Linkedmessages String The Linkedmessages column for the table Users.
Linkedoauth2PermissionGrants String The Linkedoauth2PermissionGrants column for the table Users.
Linkedonenote String The Linkedonenote column for the table Users.
LinkedonlineMeetings String The LinkedonlineMeetings column for the table Users.
Linkedoutlook String The Linkedoutlook column for the table Users.
LinkedownedDevices String The LinkedownedDevices column for the table Users.
LinkedownedObjects String The LinkedownedObjects column for the table Users.
Linkedpeople String The Linkedpeople column for the table Users.
Linkedphoto String The Linkedphoto column for the table Users.
Linkedphotos String The Linkedphotos column for the table Users.
Linkedplanner String The Linkedplanner column for the table Users.
LinkedregisteredDevices String The LinkedregisteredDevices column for the table Users.
Linkedsettings String The Linkedsettings column for the table Users.
LinkedtransitiveMemberOf String The LinkedtransitiveMemberOf column for the table Users.
createdByUserId String The createdByUserId column for the table Users.
createdByUserDisplayName String The createdByUserDisplayName column for the table Users.
lastModifiedByUserId String The lastModifiedByUserId column for the table Users.
lastModifiedByUserDisplayName String The lastModifiedByUserDisplayName column for the table Users.
createdByUserId String The createdByUserId column for the table Users.
createdByUserDisplayName String The createdByUserDisplayName column for the table Users.
lastModifiedByUserId String The lastModifiedByUserId column for the table Users.
lastModifiedByUserDisplayName String The lastModifiedByUserDisplayName column for the table Users.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7656