UserPresence
Stores real-time presence information for Microsoft Teams users.
Table Specific Information
Select
The add-in will use the Microsoft Teams API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the add-in.
- Id supports '=' operator.
Following is an example query:
SELECT * FROM UserPresence WHERE Id = '142478877'
SELECT * FROM UserPresence WHERE Id IN ('0409f710-2aa9-4f05-8944-ef382160f1d1', '04a54c2f-2402-4cee-ac8e-9eee05d0dd30')
Columns
| Name | Type | Description |
| Id | String | Unique identifier for the Microsoft Teams user. |
| Availability | String | The user's current availability status, such as Available, Away, Busy, or Do Not Disturb. |
| Activity | String | The user's current activity state in Microsoft Teams, such as In a call, In a meeting, or Presenting. |
| StatusMessage_ExpiryDateTime_DateTime | String | The date and time when the user's custom status message is set to expire. |
| StatusMessage_ExpiryDateTime_TimeZone | String | The time zone associated with the expiration date and time of the user's status message. |
| StatusMessage_Message_Content | String | The text content of the user's custom status message in Microsoft Teams. |
| StatusMessage_PublishedDateTime | Datetime | The date and time when the user's custom status message was published. |