New and Updated Graph Reporting APIs for Microsoft Teams activity

Some of the existing reporting API endpoints for Microsoft Teams activity have been updated to include additional details including audio, video and screen-sharing durations and meeting actions.

Which reports have been updated?

Get Activity Counts

The Get Activity Counts report provides a tenant-wide overview of Teams activity of licensed Teams users and has been updated with new columns for:

Number of messages posted in the reporting period
Number of replies in the reporting period
Total audio duration in the reporting period
Total video duration in the reporting period
Total screen share duration in the reporting period
Meetings organised in the reporting period
Meetings attended in the reporting period

Get Activity Total Counts

The Get Activity Total Counts report is similar to the previous report but includes non-licensed users. It also also been updated with new columns for:

Number of messages posted in the reporting period
Number of replies in the reporting period
Total audio duration in the reporting period
Total video duration in the reporting period
Total screen share duration in the reporting period
Meetings organised in the reporting period
Meetings attended in the reporting period

Get User Detail

The Get User Detail report provides detailed user-level reporting on Teams activity. To support Shared Channels, this report now includes details of the user tenant as well as their ID. New columns in this report are:

Tenant Display Name
Shared Channel Tenant Display Names
Number of messages posted in the reporting period
Number of replies sent in the reporting period
Number of urgent messages sent in the reporting period

Which reports are new?

Get total distribution activity counts

The Get total distribution activity counts is a new report that returns data similar to the Get Activity Total Counts report, but aggregated in a different way. Rather than providing a set of values for each day in the reporting period, this report provides a single set of values for the entire period. It takes a period parameter of 7, 30, 90 and 180 days and outputs in either JSON or CSV. It has the following columns:

Team chat messages posted in the reporting period
Private chat messages posted in the reporting period
Calls in the reporting period
Meetings in the reporting period
Meetings organized in the reporting period
Meetings attended in the reporting period
Audio duration in the reporting period
Video duration in the reporting period
Screen share duration in the reporting period
Post messages in the reporting period
Reply messages in the reporting period
Report period in the reporting period

Example output from this report. Notice that regardless of how many days in the reporting period, a single set of results is returned, aggregated the period:


{
  "@odata.context": "https://graph.microsoft.com/beta/getTeamsUserActivityTotalDistributionCounts(period='D7')", 
  "value": [
      "reportRefreshDate": "2022-04-08", 
      "userCounts"
        {
          "reportPeriod":7,
          "teamChatMessages": 26, 
          "privateChatMessages": 17, 
          "calls": 4, 
          "meetings": 0, 
          "meetingsOrganized": 0,
          "meetingsAttended": 0,
          "audioDuration": "P16DT8H9M41S",
          "videoDuration": "P11DT16H37M51S",
          "screenShareDuration": "P11DT17H16M28S",
          "postMessages": 1,
          "replyMessages": 1
    }
  ]
}

The durations are returned in the ISO8601 Duration format, which may be somewhat unfamiliar to developers.

Right now all these changes are only reflected in the /beta version of the reports.