Users
Lists all Azure AD users, including their profile and directory information, within the authenticated permissions.
Table Specific Information
Select
Query the Users table. The 本製品 will use the Azure Active Directory API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- Id supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM Users WHERE Id = '08d30c14-2775-45c9-8809-3eca47340959'
Note: when querying the Users table with an asterik (*), only the default columns will be returned. (i.e. businessPhones, displayName, givenName, id, jobTitle, mail, mobilePhone, officeLocation, preferredLanguage, surname, userPrincipalName)
To get the data for extra columns in the Users table, you must provide them in the query. For example:
SELECT id, department, officeLocation, state, displayName, mail FROM Users
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')
Update
To update a user record you need to specify the Id in WHERE clause.
UPDATE Users SET JobTitle = 'New Job Title' WHERE Id = 'bc48eaf7-0dc6-45d1-b17a-5b5397466ee1'
Delete
To delete a user record, you need to specify the Id in WHERE clause.
DELETE FROM Users WHERE Id = 'bc48eaf7-0dc6-45d1-b17a-5b5397466ee1'
GetDeleted
Retrieve recently deleted users. Deleted users remain available for up to 30 days.
GETDELETED FROM Users
Columns
| Name | Type | ReadOnly | Description |
| Manager_Id | String | False |
The unique identifier assigned to the manager of the user. |
| Manager_DisplayName | String | False |
The display name of the user's manager, typically used for display purposes. |
| id [KEY] | String | False |
The unique identifier of the user within the directory. |
| deletedDateTime | Datetime | False |
The timestamp indicating when the user was deleted from the directory. |
| accountEnabled | Bool | False |
A flag indicating whether the user's account is currently active. |
| assignedLicenses | String | False |
A list of licenses assigned to the user, detailing their access to specific services. |
| businessPhones | String | False |
The business phone numbers associated with the user. |
| city | String | False |
The city specified in the user's profile. |
| companyName | String | False |
The name of the company associated with the user. |
| country | String | False |
The country or region where the user resides. |
| createdDateTime | Datetime | False |
The date and time when the user account was created. |
| department | String | False |
The department in which the user works. |
| displayName | String | False |
The user's full name, commonly displayed in user interfaces. |
| employeeHireDate | Datetime | False |
The date the user was hired by the organization. |
| employeeId | String | False |
The unique employee ID assigned to the user by the organization. |
| employeeOrgData_costCenter | String | False |
The cost center associated with the user's organizational data. |
| employeeOrgData_division | String | False |
The division of the organization to which the user belongs. |
| employeeType | String | False |
The employment type of the user, such as 'Full-Time' or 'Contractor'. |
| givenName | String | False |
The user's first name or given name. |
| identities | String | False |
A list of identity providers and identifiers associated with the user. |
| imAddresses | String | False |
The instant messaging addresses associated with the user. |
| isManagementRestricted | Bool | False |
Indicates whether the user has restrictions due to management policies. |
| isResourceAccount | Bool | False |
Specifies if the user account is designated as a resource account. |
| jobTitle | String | False |
The user's job title within the organization. |
| lastPasswordChangeDateTime | Datetime | False |
The timestamp of the user's last password change. |
| String | False |
The primary email address of the user. | |
| mailNickname | String | False |
The mail alias or nickname for the user. |
| mobilePhone | String | False |
The user's mobile phone number. |
| officeLocation | String | False |
The location of the user's office, typically a building or room number. |
| onPremisesDistinguishedName | String | False |
The distinguished name of the user in the on-premises directory. |
| onPremisesDomainName | String | False |
The domain name associated with the user in the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute1 | String | False |
Custom extension attribute 1 defined in the on-premises directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute10 | String | False |
Custom extension attribute 10 defined in the on-premises directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute11 | String | False |
Custom extension attribute 11 defined in the on-premises directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute12 | String | False |
Custom extension attribute 12 defined in the on-premises directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute13 | String | False |
Custom extension attribute 13 defined in the on-premises directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute14 | String | False |
Custom extension attribute 14 defined in the on-premises directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute15 | String | False |
Custom extension attribute 15 defined in the on-premises directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute2 | String | False |
Custom extension attribute 2 defined in the on-premises directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute3 | String | False |
Custom extension attribute 3 defined in the on-premises directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute4 | String | False |
Custom extension attribute 4 defined in the on-premises directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute5 | String | False |
Custom extension attribute 5 defined in the on-premises directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute6 | String | False |
Custom extension attribute 6 defined in the on-premises directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute7 | String | False |
Custom extension attribute 7 defined in the on-premises directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute8 | String | False |
Custom extension attribute 8 defined in the on-premises directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute9 | String | False |
Custom extension attribute 9 defined in the on-premises directory for the user. |
| onPremisesImmutableId | String | False |
The immutable identifier assigned to the user in the on-premises directory. |
| onPremisesLastSyncDateTime | Datetime | False |
The timestamp of the user's last synchronization with the on-premises directory. |
| onPremisesProvisioningErrors | String | False |
Details of provisioning errors encountered during synchronization. |
| onPremisesSamAccountName | String | False |
The Security Account Manager (SAM) account name of the user in the on-premises directory. |
| onPremisesSecurityIdentifier | String | False |
The unique security identifier (SID) of the user in the on-premises directory. |
| onPremisesSyncEnabled | Bool | False |
A flag indicating whether synchronization with the on-premises directory is enabled. |
| onPremisesUserPrincipalName | String | False |
The User Principal Name (UPN) of the user in the on-premises directory. |
| otherMails | String | False |
Additional email addresses associated with the user. |
| passwordProfile_forceChangePasswordNextSignIn | Bool | False |
Indicates whether the user is required to change their password at the next sign-in. |
| passwordProfile_forceChangePasswordNextSignInWithMfa | Bool | False |
Indicates if the user must change their password and complete MFA at the next sign-in. |
| passwordProfile_password | String | False |
The password profile configured for the user account. |
| postalCode | String | False |
The postal code of the user's address. |
| preferredLanguage | String | False |
The language preference specified by the user. |
| serviceProvisioningErrors | String | False |
Details of errors encountered during service provisioning. |
| state | String | False |
The state or province of the user's address. |
| streetAddress | String | False |
The street address of the user. |
| surname | String | False |
The last name or surname of the user. |
| userPrincipalName | String | False |
The unique UPN of the user within the directory, often used for authentication. |
| userType | String | False |
The type of user, such as 'Member' or 'Guest'. |