UserPresence
Stores real-time presence information for Microsoft Teams users.
Table Specific Information
Select
The component 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 component.
- 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. |