Users
Contains detailed profile, organizational, and directory synchronization information for users in Microsoft Teams, including contact details, licensing, job roles, and Active Directory mappings.
Table Specific Information
Select
Query the Users table. The server will use the Microsoft Teams API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the server.
- Id supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM Users WHERE Id = '08d30c14-2775-45c9-8809-3eca47340959'
Columns
| Name | Type | Description |
| id [KEY] | String | Unique identifier for the user in Microsoft Teams. |
| deletedDateTime | Datetime | Timestamp indicating when the user account was deleted, if applicable. |
| accountEnabled | Bool | Indicates whether the user's account is currently enabled. |
| assignedLicenses | String | List of product licenses currently assigned to the user. |
| businessPhones | String | Collection of the user's business phone numbers. |
| city | String | City listed in the user's organizational profile. |
| companyName | String | Name of the company the user is associated with. |
| country | String | Country or region specified in the user's profile. |
| createdDateTime | Datetime | Timestamp when the user account was created. |
| department | String | Department name listed in the user's organizational information. |
| displayName | String | Full name displayed for the user in Teams and other services. |
| employeeHireDate | Datetime | Date the user was hired, according to their employee record. |
| employeeId | String | Identifier assigned to the user in the employee directory. |
| employeeOrgData_costCenter | String | Cost center code associated with the user's organizational unit. |
| employeeOrgData_division | String | Division in which the user is employed within the organization. |
| employeeType | String | Classification of the user's employment, such as Full-time or Contractor. |
| givenName | String | The user's first name. |
| identities | String | Collection of identity records used for sign-in and directory purposes. |
| imAddresses | String | List of Instant Messaging (IM) addresses associated with the user. |
| isManagementRestricted | Bool | Indicates whether the user is restricted from being managed by others. |
| isResourceAccount | Bool | Specifies whether the user account is a resource account. |
| jobTitle | String | Job title listed in the user's profile. |
| lastPasswordChangeDateTime | Datetime | Timestamp of the user's most recent password change. |
| String | Primary email address associated with the user. | |
| mailNickname | String | Nickname used to generate the user's email address. |
| mobilePhone | String | User's mobile phone number. |
| officeLocation | String | Office building or physical location assigned to the user. |
| onPremisesDistinguishedName | String | User's distinguished name in the on-premises Active Directory. |
| onPremisesDomainName | String | Name of the on-premises domain the user is associated with. |
| onPremisesExtensionAttributes_extensionAttribute1 | String | Custom extension attribute 1 from the on-premises Active Directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute10 | String | Custom extension attribute 10 from the on-premises Active Directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute11 | String | Custom extension attribute 11 from the on-premises Active Directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute12 | String | Custom extension attribute 12 from the on-premises Active Directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute13 | String | Custom extension attribute 13 from the on-premises Active Directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute14 | String | Custom extension attribute 14 from the on-premises Active Directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute15 | String | Custom extension attribute 15 from the on-premises Active Directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute2 | String | Custom extension attribute 2 from the on-premises Active Directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute3 | String | Custom extension attribute 3 from the on-premises Active Directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute4 | String | Custom extension attribute 4 from the on-premises Active Directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute5 | String | Custom extension attribute 5 from the on-premises Active Directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute6 | String | Custom extension attribute 6 from the on-premises Active Directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute7 | String | Custom extension attribute 7 from the on-premises Active Directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute8 | String | Custom extension attribute 8 from the on-premises Active Directory for the user. |
| onPremisesExtensionAttributes_extensionAttribute9 | String | Custom extension attribute 9 from the on-premises Active Directory for the user. |
| onPremisesImmutableId | String | Unique, immutable identifier used to map the user to an on-premises Active Directory object. |
| onPremisesLastSyncDateTime | Datetime | Timestamp of the last directory synchronization from on-premises Active Directory to Microsoft 365. |
| onPremisesProvisioningErrors | String | Collection of errors encountered during the on-premises provisioning process for the user. |
| onPremisesSamAccountName | String | Security Account Manager (SAM) account name of the user in the on-premises Active Directory. |
| onPremisesSecurityIdentifier | String | Security Identifier (SID) associated with the user's on-premises Active Directory account. |
| onPremisesSyncEnabled | Bool | Indicates whether synchronization with the on-premises directory is enabled for the user. |
| onPremisesUserPrincipalName | String | User Principal Name (UPN) of the user in the on-premises environment. |
| otherMails | String | Collection of additional email addresses associated with the user. |
| passwordProfile_forceChangePasswordNextSignIn | Bool | Indicates whether the user must change their password at the next sign-in. |
| passwordProfile_forceChangePasswordNextSignInWithMfa | Bool | Indicates whether the user must change their password at the next sign-in using multi-factor authentication. |
| passwordProfile_password | String | Password value to set during user creation. |
| postalCode | String | Postal code or ZIP code listed in the user's address information. |
| preferredLanguage | String | The user's preferred language, typically used for localization and communication settings. |
| serviceProvisioningErrors | String | List of errors encountered during the provisioning of services for the user. |
| state | String | State or province listed in the user's address details. |
| streetAddress | String | Street-level address of the user's physical or mailing location. |
| surname | String | User's family name or last name. |
| userPrincipalName | String | The user's sign-in name, usually formatted as an email address. |
| userType | String | |
| Authentication_id | String | Unique identifier for the user's authentication container. |
| Calendar_id | String | Unique identifier for the user's calendar. |
| Drive_id | String | Unique identifier for the user's OneDrive drive. |
| InferenceClassification_id | String | Unique identifier for the user's email classification preferences. |
| Insights_id | String | Unique identifier for insights related to the user, such as activity and collaboration data. |
| Manager_id | String | Identifier for the user's manager in the organizational directory. |
| Onenote_id | String | Unique identifier for the user's OneNote data container. |
| Outlook_id | String | Unique identifier for the user's Outlook data container. |
| Photo_id | String | Identifier for the user's profile photo resource. |
| Planner_id | String | Identifier for the user's Microsoft Planner resource. |
| Presence_id | String | Identifier for the user's presence data in Microsoft Teams. |
| Settings_id | String | Identifier for the user's settings container. |
| Teamwork_id | String | Identifier for the user's Microsoft Teams collaboration container. |
| Todo_id | String | Identifier for the user's Microsoft To Do task list. |