ODBC Driver for Exchange

Build 20.0.7587

Users

Users table for Exchange data provider.

テーブル固有の情報

Select

Users からすべてを取得したり、Id を指定したり、カラムでフィルタリングしたりすることで、Users テーブルをクエリします。

SELECT * FROM Users WHERE Id = '616391f0-32d8-4127-8f25-aa55771d6617'

SELECT DisplayName, Id FROM Users WHERE DisplayName LIKE 'John%'

Insert

新しい組織User を作成するには、以下が必要です。

INSERT INTO Users (AccountEnabled, DisplayName, MailNickname, UserPrincipalName, PasswordProfile_ForceChangePasswordNextSignIn, PasswordProfile_Password) VALUES (false, 'John Smith', 'JohnS', 'smithjohn@yourcompanydomain.com', true, '123password')

Columns

Name Type ReadOnly Description
id [KEY] String False

deletedDateTime Datetime False

aboutMe String False

accountEnabled Bool False

ageGroup String False

assignedLicenses String False

assignedPlans String False

birthday Datetime False

businessPhones String False

city String False

companyName String False

consentProvidedForMinor String False

country String False

department String False

deviceEnrollmentLimit Int False

displayName String False

employeeId String False

faxNumber String False

givenName String False

hireDate Datetime False

imAddresses String False

interests String False

isResourceAccount Bool False

jobTitle String False

legalAgeGroupClassification String False

licenseAssignmentStates String False

mail String False

mailboxSettings_automaticRepliesSetting_status String False

mailboxSettings_automaticRepliesSetting_externalAudience String False

mailboxSettings_automaticRepliesSetting_scheduledStartDateTime_dateTime String False

mailboxSettings_automaticRepliesSetting_scheduledStartDateTime_timeZone String False

mailboxSettings_automaticRepliesSetting_internalReplyMessage String False

mailboxSettings_automaticRepliesSetting_externalReplyMessage String False

mailboxSettings_archiveFolder String False

mailboxSettings_timeZone String False

mailboxSettings_language_locale String False

mailboxSettings_language_displayName String False

mailboxSettings_workingHours_daysOfWeek String False

mailboxSettings_workingHours_startTime Time False

mailboxSettings_workingHours_endTime Time False

mailboxSettings_workingHours_timeZone_name String False

mailNickname String False

mobilePhone String False

mySite String False

officeLocation String False

onPremisesDistinguishedName String False

onPremisesDomainName String False

onPremisesExtensionAttributes_extensionAttribute1 String False

onPremisesExtensionAttributes_extensionAttribute2 String False

onPremisesExtensionAttributes_extensionAttribute3 String False

onPremisesExtensionAttributes_extensionAttribute4 String False

onPremisesExtensionAttributes_extensionAttribute5 String False

onPremisesExtensionAttributes_extensionAttribute6 String False

onPremisesExtensionAttributes_extensionAttribute7 String False

onPremisesExtensionAttributes_extensionAttribute8 String False

onPremisesExtensionAttributes_extensionAttribute9 String False

onPremisesExtensionAttributes_extensionAttribute10 String False

onPremisesExtensionAttributes_extensionAttribute11 String False

onPremisesExtensionAttributes_extensionAttribute12 String False

onPremisesExtensionAttributes_extensionAttribute13 String False

onPremisesExtensionAttributes_extensionAttribute14 String False

onPremisesExtensionAttributes_extensionAttribute15 String False

onPremisesImmutableId String False

onPremisesLastSyncDateTime Datetime False

onPremisesProvisioningErrors String False

onPremisesSamAccountName String False

onPremisesSecurityIdentifier String False

onPremisesSyncEnabled Bool False

onPremisesUserPrincipalName String False

otherMails String False

passwordPolicies String False

passwordProfile_password String False

passwordProfile_forceChangePasswordNextSignIn Bool False

passwordProfile_forceChangePasswordNextSignInWithMfa Bool False

pastProjects String False

postalCode String False

preferredLanguage String False

preferredName String False

provisionedPlans String False

proxyAddresses String False

responsibilities String False

schools String False

showInAddressList Bool False

signInSessionsValidFromDateTime Datetime False

skills String False

state String False

streetAddress String False

surname String False

usageLocation String False

userPrincipalName String False

userType String False

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