Users

Supports reading, creating, updating, and deleting Office365 user accounts. Includes profile and licensing details.

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		Globally Unique Identifier (GUID) assigned to the user object in Azure Active Directory.
deletedDateTime	Datetime	False		Timestamp when the user was soft deleted from the directory; null if the account is active.
accountEnabled	Bool	False		Indicates whether the account is enabled for sign-in and Azure AD authentication.
businessPhones	String	False		Comma-separated list of business phone numbers for the user, in E.164 or in local format, for example +1 4255550100, +1 4255550120.
city	String	False		City portion of the user's physical address.
companyName	String	False		Name of the company or organization where the user works.
country	String	False		Country or region listed in the user's address.
createdDateTime	Datetime	False		Timestamp when the user account was created in Azure Active Directory.
department	String	False		Department or organizational unit the user belongs to.
displayName	String	False		Full display name for the user, shown in address books and Teams.
employeeHireDate	Datetime	False		Date when the employee was hired, according to human resources records.
employeeId	String	False		Employee identifier used by payroll or HR systems.
employeeLeaveDateTime	Datetime	False		Date and time when the employee left the organization; null if still employed.
employeeOrgData_costCenter	String	False		Cost center code associated with the user for financial tracking.
employeeOrgData_division	String	False		Division name within the organization associated with the user.
employeeType	String	False		Classification of employment, such as Employee, Contractor, or Vendor.
givenName	String	False		User's given name (first name).
identities	String	False		Collection of sign-in identities for the user, each with issuer, issuerAssignedId, and signInType.
imAddresses	String	False		Comma-separated list of instant messaging addresses for the user, for example sip:[email protected], sip:[email protected].
isResourceAccount	Bool	False		Indicates whether this account represents a resource such as a room or equipment mailbox.
jobTitle	String	False		Job title of the user, such as Senior Analyst.
lastPasswordChangeDateTime	Datetime	False		Most recent date and time when the user changed their password.
mail	String	False		Primary SMTP email address for the user.
mailNickname	String	False		Alias used to generate the user's email address; must be unique within the tenant.
mobilePhone	String	False		Mobile phone number for the user, stored in E.164 format where possible.
officeLocation	String	False		Office location, room number, or desk identifier for the user.
onPremisesDistinguishedName	String	False		Distinguished name (DN) of the on-premises Active Directory object mapped to the user.
onPremisesDomainName	String	False		Domain name of the on-premises Active Directory forest where the user originates.
onPremisesExtensionAttributes_extensionAttribute1	String	False		Custom extension attribute 1 replicated from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute10	String	False		Custom extension attribute 10 replicated from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute11	String	False		Custom extension attribute 11 replicated from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute12	String	False		Custom extension attribute 12 replicated from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute13	String	False		Custom extension attribute 13 replicated from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute14	String	False		Custom extension attribute 14 replicated from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute15	String	False		Custom extension attribute 15 replicated from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute2	String	False		Custom extension attribute 2 replicated from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute3	String	False		Custom extension attribute 3 replicated from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute4	String	False		Custom extension attribute 4 replicated from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute5	String	False		Custom extension attribute 5 replicated from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute6	String	False		Custom extension attribute 6 replicated from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute7	String	False		Custom extension attribute 7 replicated from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute8	String	False		Custom extension attribute 8 replicated from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute9	String	False		Custom extension attribute 9 replicated from on-premises Active Directory.
onPremisesImmutableId	String	False		Immutable identifier used to map the cloud user to an on-premises Active Directory object.
onPremisesLastSyncDateTime	Datetime	False		Timestamp of the most recent synchronization from on-premises Active Directory.
onPremisesProvisioningErrors	String	False		List of provisioning errors returned during directory synchronization.
onPremisesSamAccountName	String	False		SAMAccountName from on-premises Active Directory, used for legacy authentication.
onPremisesSecurityIdentifier	String	False		Security identifier (SID) assigned to the on-premises object.
onPremisesSyncEnabled	Bool	False		Indicates whether the object continues to synchronize from on-premises Active Directory.
onPremisesUserPrincipalName	String	False		User principal name (UPN) of the on-premises object.
otherMails	String	False		Comma-separated collection of additional SMTP addresses associated with the user, such as [email protected], [email protected].
passwordProfile_forceChangePasswordNextSignIn	Bool	False		Indicates whether the user must change password at the next sign-in.
passwordProfile_forceChangePasswordNextSignInWithMfa	Bool	False		Indicates whether the user must change password at next sign-in and complete multifactor authentication.
passwordProfile_password	String	False		Write-only initial password set for the user during creation or reset.
postalCode	String	False		Postal or ZIP code portion of the user's address.
preferredLanguage	String	False		Preferred language for the user, expressed as an ISO language tag such as en-US.
securityIdentifier	String	False		SID assigned to the user in Azure Active Directory.
state	String	False		State or province portion of the user's physical address.
streetAddress	String	False		Street name, number, and unit for the user's physical address.
surname	String	False		User's family name (last name).
userPrincipalName	String	False		Principal name the user uses to sign in, typically of the form [email protected].
userType	String	False		Identifies the type of user: Member for internal users, Guest for external users invited to the tenant.

Excel Add-In for Microsoft Office 365

Users

Table Specific Information

Select

Insert

Columns