How to get user activities in Teams using Microsoft Graph

The getTeamsUserActivityUserDetail method helps return user activity details in Microsoft Teams. You can generate the report for specific day range or a particular date. If you're choosing to generate the report for specific number of days then it must be in the format 'Dn' where n= number of days (i.e., D7, D30, D90 or D180). The report queried for a specific date must have the date in the YYYY-MM-DD format and this report can be queried only for the past 30 days. You can use the method below to retrieve information using the Microsoft Graph Explorer.

If this method is successful, it will return a 302 Found response that redirects to a preauthenticated download URL for a CSV file report which will consist of details such as User Principal Name, Last Activity Date, Deleted Date, Team Chat Message Count, Private Chat Message Count, etc. This URL is valid for only a few minutes.

Example:

Get activities count

This method returns the number of user activities performed in Microsoft Teams for the specified time range . The time range value must be in the 'Dn' format where n= number of days (i.e., D7, D30, D90 or D180).

If this method is successful, it will return a 302 Found response that redirects to a preauthenticated download URL for a CSV file report which will consist of details such as Report Refresh Date, Report Date, Team Chat Messages, Private Chat Messages, Calls, Meetings, and Report Period. This URL is valid for only a few minutes.

Get user count

This method returns the total count of user activities in Microsoft Teams by activity type such as teams chat messages, private chat messages, calls, or meetings for the selected time range. The time range should be specified in the 'Dn' format where n= number of days (i.e., D7, D30, D90 or D180).

If this method is successful, it will return a 302 Found response that redirects to a preauthenticated download URL for a CSV file report which will consist of details such as Report Refresh Date, Report Date, Team Chat Messages, Private Chat Messages, Calls, Meetings, etc. This URL is valid for only a few minutes.

Retrieving information using Microsoft Graph requires you to have the Reports.Read.All permission. It can also be complex, time-consuming, and error-prone. M365 Manager Plus, the complete Microsoft 365 tool, helps gain extensive information on Microsoft Teams effortlessly, with its preconfigured reports.

How can M365 Manager Plus help?

M365 Manager Plus offers comprehensive reports that help gain insights on the different facets of Microsoft Teams in a few easy clicks. The results can be filtered to display only the required information.

You can also schedule specific reports to be generated on an hourly, daily, weekly, or monthly basis. You can choose to be notified when the reports are generated and have them delivered straight to your inbox. The reports can also be exported to various formats, including CSV, XLSX, PDF, and HTML.

To get user activities count using M365 Manager Plus:

1. Navigate to the Reports tab.
2. Go to Other Services in the left pane.
3. Select Teams Usage Reports → Teams User Daily Activity.
4. Select the required Microsoft 365 Tenant and Period to generate the report.

M365 Manager Plus also offers the following reports that can help audit Microsoft Teams.

• All Teams
• Team Channels
• Team Members
• Team Sizes
• Daily Teams User Count by Device Usage
• Daily Teams Activities Count by Type
• Daily Teams User Count by Activity
• Teams User Device Usage
• Teams User Count by Device Type

To know more about Microsoft Teams reporting using M365 Manager Plus, click here.