Users
Retrieves all Azure AD user accounts within the authenticated permissions.
Table Specific Information
Select
Query the Users table. The adapter will use the AzureActiveDirectory API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the adapter.
- Id supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM Users WHERE Id = '08d30c14-2775-45c9-8809-3eca47340959'
GetDeleted
Retrieve recently deleted users. Deleted users remain available for up to 30 days.
GETDELETED FROM Users
Columns
| Name | Type | ReadOnly | Description |
| id [KEY] | String | False |
The id of the user. |
| deletedDateTime | Datetime | False |
The deletedDateTime of the user. |
| aboutMe | String | False |
The aboutMe of the user. |
| accountEnabled | Bool | False |
Indicates if accountEnabled for the user. |
| ageGroup | String | False |
The ageGroup of the user. |
| assignedLicenses | String | False |
The assignedLicenses of the user. |
| assignedPlans | String | False |
The assignedPlans of the user. |
| birthday | Datetime | False |
The birthday of the user. |
| businessPhones | String | False |
The businessPhones of the user. |
| city | String | False |
The city of the user. |
| companyName | String | False |
The companyName of the user. |
| consentProvidedForMinor | String | False |
The consentProvidedForMinor of the user. |
| country | String | False |
The country of the user. |
| createdDateTime | Datetime | False |
The createdDateTime of the user. |
| creationType | String | False |
The creationType of the user. |
| department | String | False |
The department of the user. |
| deviceEnrollmentLimit | Int | False |
The deviceEnrollmentLimit of the user. |
| displayName | String | False |
The displayName of the user. |
| employeeHireDate | Datetime | False |
The employeeHireDate of the user. |
| employeeId | String | False |
The employeeId of the user. |
| employeeOrgData_costCenter | String | False |
The employeeOrgData_costCenter of the user. |
| employeeOrgData_division | String | False |
The employeeOrgData_division of the user. |
| employeeType | String | False |
The employeeType of the user. |
| externalUserState | String | False |
The externalUserState of the user. |
| externalUserStateChangeDateTime | Datetime | False |
The externalUserStateChangeDateTime of the user. |
| faxNumber | String | False |
The faxNumber of the user. |
| givenName | String | False |
The givenName of the user. |
| hireDate | Datetime | False |
The hireDate of the user. |
| identities | String | False |
The identities of the user. |
| imAddresses | String | False |
The imAddresses of the user. |
| interests | String | False |
The interests of the user. |
| isResourceAccount | Bool | False |
Indicates if it isResourceAccount of the user. |
| jobTitle | String | False |
The jobTitle of the user. |
| lastPasswordChangeDateTime | Datetime | False |
The lastPasswordChangeDateTime of the user. |
| legalAgeGroupClassification | String | False |
The legalAgeGroupClassification of the user. |
| licenseAssignmentStates | String | False |
The licenseAssignmentStates of the user. |
| String | False |
The mail of the user. | |
| mailboxSettings_archiveFolder | String | False |
The mailboxSettings_archiveFolder of the user. |
| mailboxSettings_automaticRepliesSetting_externalAudience | String | False |
The mailboxSettings_automaticRepliesSetting_externalAudience of the user. |
| mailboxSettings_automaticRepliesSetting_externalReplyMessage | String | False |
The mailboxSettings_automaticRepliesSetting_externalReplyMessage of the user. |
| mailboxSettings_automaticRepliesSetting_internalReplyMessage | String | False |
The mailboxSettings_automaticRepliesSetting_internalReplyMessage of the user. |
| mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_dateTime | Datetime | False |
The mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_dateTime of the user. |
| mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_timeZone | String | False |
The mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_timeZone of the user. |
| mailboxSettings_automaticRepliesSetting_status | String | False |
The mailboxSettings_automaticRepliesSetting_status of the user. |
| mailboxSettings_dateFormat | String | False |
The mailboxSettings_dateFormat of the user. |
| mailboxSettings_delegateMeetingMessageDeliveryOptions | String | False |
The mailboxSettings_delegateMeetingMessageDeliveryOptions of the user. |
| mailboxSettings_language_displayName | String | False |
The mailboxSettings_language_displayName of the user. |
| mailboxSettings_language_locale | String | False |
The mailboxSettings_language_locale of the user. |
| mailboxSettings_timeFormat | String | False |
The mailboxSettings_timeFormat of the user. |
| mailboxSettings_timeZone | String | False |
The mailboxSettings_timeZone of the user. |
| mailboxSettings_userPurpose | String | False |
The mailboxSettings_userPurpose of the user. |
| mailboxSettings_workingHours_daysOfWeek | String | False |
The mailboxSettings_workingHours_daysOfWeek of the user. |
| mailboxSettings_workingHours_endTime | Time | False |
The mailboxSettings_workingHours_endTime of the user. |
| mailboxSettings_workingHours_startTime | Time | False |
The mailboxSettings_workingHours_startTime of the user. |
| mailboxSettings_workingHours_timeZone_name | String | False |
The mailboxSettings_workingHours_timeZone_name of the user. |
| mailNickname | String | False |
The mailNickname of the user. |
| mobilePhone | String | False |
The mobilePhone of the user. |
| mySite | String | False |
The mySite of the user. |
| officeLocation | String | False |
The officeLocation of the user. |
| onPremisesDistinguishedName | String | False |
The onPremisesDistinguishedName of the user. |
| onPremisesDomainName | String | False |
The onPremisesDomainName of the user. |
| onPremisesExtensionAttributes_extensionAttribute1 | String | False |
The onPremisesExtensionAttributes_extensionAttribute1 of the user. |
| onPremisesExtensionAttributes_extensionAttribute10 | String | False |
The onPremisesExtensionAttributes_extensionAttribute10 of the user. |
| onPremisesExtensionAttributes_extensionAttribute11 | String | False |
The onPremisesExtensionAttributes_extensionAttribute11 of the user. |
| onPremisesExtensionAttributes_extensionAttribute12 | String | False |
The onPremisesExtensionAttributes_extensionAttribute12 of the user. |
| onPremisesExtensionAttributes_extensionAttribute13 | String | False |
The onPremisesExtensionAttributes_extensionAttribute13 of the user. |
| onPremisesExtensionAttributes_extensionAttribute14 | String | False |
The onPremisesExtensionAttributes_extensionAttribute14 of the user. |
| onPremisesExtensionAttributes_extensionAttribute15 | String | False |
The onPremisesExtensionAttributes_extensionAttribute15 of the user. |
| onPremisesExtensionAttributes_extensionAttribute2 | String | False |
The onPremisesExtensionAttributes_extensionAttribute2 of the user. |
| onPremisesExtensionAttributes_extensionAttribute3 | String | False |
The onPremisesExtensionAttributes_extensionAttribute3 of the user. |
| onPremisesExtensionAttributes_extensionAttribute4 | String | False |
The onPremisesExtensionAttributes_extensionAttribute4 of the user. |
| onPremisesExtensionAttributes_extensionAttribute5 | String | False |
The onPremisesExtensionAttributes_extensionAttribute5 of the user. |
| onPremisesExtensionAttributes_extensionAttribute6 | String | False |
The onPremisesExtensionAttributes_extensionAttribute6 of the user. |
| onPremisesExtensionAttributes_extensionAttribute7 | String | False |
The onPremisesExtensionAttributes_extensionAttribute7 of the user. |
| onPremisesExtensionAttributes_extensionAttribute8 | String | False |
The onPremisesExtensionAttributes_extensionAttribute8 of the user. |
| onPremisesExtensionAttributes_extensionAttribute9 | String | False |
The onPremisesExtensionAttributes_extensionAttribute9 of the user. |
| onPremisesImmutableId | String | False |
The onPremisesImmutableId of the user. |
| onPremisesLastSyncDateTime | Datetime | False |
The onPremisesLastSyncDateTime of the user. |
| onPremisesProvisioningErrors | String | False |
The onPremisesProvisioningErrors of the user. |
| onPremisesSamAccountName | String | False |
The onPremisesSamAccountName of the user. |
| onPremisesSecurityIdentifier | String | False |
The onPremisesSecurityIdentifier of the user. |
| onPremisesSyncEnabled | Bool | False |
Indicates onPremisesSyncEnabled for the user. |
| onPremisesUserPrincipalName | String | False |
The onPremisesUserPrincipalName of the user. |
| otherMails | String | False |
The otherMails of the user. |
| passwordPolicies | String | False |
The passwordPolicies of the user. |
| passwordProfile_forceChangePasswordNextSignIn | Bool | False |
Indicate passwordProfile_forceChangePasswordNextSignIn for the user. |
| passwordProfile_forceChangePasswordNextSignInWithMfa | Bool | False |
Indicate passwordProfile_forceChangePasswordNextSignInWithMfa for the user. |
| passwordProfile_password | String | False |
The passwordProfile_password of the user. |
| pastProjects | String | False |
The pastProjects of the user. |
| postalCode | String | False |
The postalCode of the user. |
| preferredLanguage | String | False |
The preferredLanguage of the user. |
| preferredName | String | False |
The preferredName of the user. |
| provisionedPlans | String | False |
The provisionedPlans of the user. |
| proxyAddresses | String | False |
The proxyAddresses of the user. |
| responsibilities | String | False |
The responsibilities of the user. |
| schools | String | False |
The schools of the user. |
| showInAddressList | Bool | False |
Indicate showInAddressList of the user. |
| signInSessionsValidFromDateTime | Datetime | False |
The signInSessionsValidFromDateTime of the user. |
| skills | String | False |
The skills of the user. |
| state | String | False |
The state of the user. |
| streetAddress | String | False |
The streetAddress of the user. |
| surname | String | False |
The surname of the user. |
| usageLocation | String | False |
The usageLocation of the user. |
| userPrincipalName | String | False |
The userPrincipalName of the user. |
| userType | String | False |
The userType of the user. |