Users
Contains detailed profile, organizational, and directory synchronization information for users in Microsoft Teams, including contact details, licensing, job roles, and Active Directory mappings.
テーブル固有の情報
Select
Users テーブルをクエリします。connector は Microsoft Teams API を使用して、以下のカラムと演算子で作成されたWHERE 句条件を処理します。その他のフィルタはクライアントサイドでconnector 内部で処理されます。
- Id は、'=' 演算子をサポートします。
例えば、次のクエリはサーバーサイドで処理されます。
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. |