Users

The Office365 table Users.

Table Specific Information

Select

Query the Users table by retrieving everything from Users, specifying a Id, or filtering by a column:

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

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

Insert

The following are required to create a new organizational 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

JDBC Driver for Microsoft Office 365

Users

Table Specific Information

Select

Insert

Columns