Users
The Office365 table Users.
テーブル固有の情報
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', '[email protected]', true, '123password')
Columns
Name | Type | ReadOnly | References | Description |
id [KEY] | String | True | ||
Etag | String | False | ||
deletedDateTime | Datetime | False | ||
accountEnabled | Bool | False | ||
ageGroup | String | False | ||
assignedLicenses | String | False | ||
assignedPlans | String | False | ||
businessPhones | String | False | ||
city | String | False | ||
companyName | String | False | ||
consentProvidedForMinor | String | False | ||
country | String | False | ||
createdDateTime | Datetime | False | ||
creationType | String | False | ||
department | String | False | ||
displayName | String | False | ||
employeeHireDate | Datetime | False | ||
employeeId | String | False | ||
employeeOrgData_costCenter | String | False | ||
employeeOrgData_division | String | False | ||
employeeType | String | False | ||
externalUserState | String | False | ||
externalUserStateChangeDateTime | Datetime | False | ||
faxNumber | String | False | ||
givenName | String | False | ||
identities | String | False | ||
imAddresses | String | False | ||
isResourceAccount | Bool | False | ||
jobTitle | String | False | ||
lastPasswordChangeDateTime | Datetime | False | ||
legalAgeGroupClassification | String | False | ||
licenseAssignmentStates | String | False | ||
mailNickname | String | False | ||
mobilePhone | String | False | ||
officeLocation | String | False | ||
onPremisesDistinguishedName | String | False | ||
onPremisesDomainName | 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_forceChangePasswordNextSignIn | Bool | False | ||
passwordProfile_forceChangePasswordNextSignInWithMfa | Bool | False | ||
passwordProfile_password | String | False | ||
postalCode | String | False | ||
preferredLanguage | String | False | ||
provisionedPlans | String | False | ||
proxyAddresses | String | False | ||
showInAddressList | Bool | False | ||
signInSessionsValidFromDateTime | Datetime | False | ||
state | String | False | ||
streetAddress | String | False | ||
surname | String | False | ||
usageLocation | String | False | ||
userPrincipalName | String | False | ||
userType | String | False |