YammerActivityUserDetail
Provides a detailed breakdown of user-level activity within Yammer, including metrics such as messages posted, read activities, and engagement trends over time.
Columns
| Name | Type | Description |
| ReportRefreshDate | Date | The date when the Yammer activity report was last refreshed. Reflects the most recent date for which user activity data is available. |
| UserPrincipalName | String | The user principal name (UPN) of the individual whose Yammer activity is being reported. Typically formatted as an email address and used for identity resolution. |
| DisplayName | String | The full display name of the user as it appears in Yammer. This is the name shown in user-facing interfaces. |
| UserState | String | Indicates the current state of the user account in Yammer. Possible values include Active, Deleted, or Blocked. |
| StateChangeDate | Date | The date on which the user's Yammer account state last changed. Useful for tracking recent activations or deactivations. |
| LastActivityDate | Date | The most recent date the user performed any activity in Yammer, including posting, reading, or liking messages. |
| PostedCount | Integer | The total number of messages or posts the user created in Yammer during the reporting period. |
| ReadCount | Integer | The number of messages or conversations the user viewed in Yammer during the reporting period. |
| LikedCount | Integer | The number of messages or posts the user marked with a 'like' in Yammer during the reporting period. |
| AssignedProducts | String | A comma-separated list of Microsoft services or product licenses assigned to the user. May include Yammer, Exchange Online, Teams, and others. |
| ReportPeriod | Integer | The length of time, in days, that the report covers. Typical values include 7, 30, 90, or 180, indicating how far back Yammer activity is aggregated. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Period | String | Specifies the standardized aggregation window for the report. Supported values include D7, D30, D90, and D180, where Dn represents the number of days in the reporting period.
The allowed values are D7, D30, D90, D180. The default value is D7. |
| Date | Date | The specific date (in YYYY-MM-DD format) for which Yammer activity data is requested. Only dates from the past 30 days are valid for this report. |