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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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.
使用できる値は次のとおりです。D7, D30, D90, D180 デフォルト値は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. |