Fix Teams Admin Center Usage Report Shows Zero Activity for a Security Group

Your Teams admin center usage report shows zero activity for a security group, even though members are actively using Teams. This happens because the usage report does not aggregate data by security group. The report displays per-user activity, and the group filter only narrows the list of users shown, not the underlying data. This article explains the exact cause and gives you three methods to get accurate activity data for a security group.

Why Teams Admin Center Usage Reports Show Zero Activity for a Security Group

The Teams admin center usage report shows activity for individual users, not for groups. When you apply a security group filter, the report only filters which users appear in the table. It does not sum activity across the group. If the filter returns no users, or if the users in the group have not been active in the selected time period, the report shows zero activity.

Another cause is the date range. The default report period is the last 7 days. If the group members were active before that window, the report shows zero for the current period. Also, the report only includes licensed users who have signed into Teams at least once. If the security group contains unlicensed users or users who have never launched Teams, they appear with zero activity.

Steps to Diagnose and Fix Zero Activity in the Teams Usage Report

Follow these steps to check the report settings, export the data, and verify group membership.

Step 1: Verify the Date Range and Product Filter

1. Open the Teams admin center
   Go to Teams admin center > Usage reports > Teams user activity.
2. Set the date range
   Choose Last 30 days or Last 90 days from the date picker. A 7-day window may miss activity from earlier in the month.
3. Check the product filter
   Ensure the filter is set to Teams, not All products. The Teams user activity report only shows Teams-specific actions like channel messages, replies, and calls.

Step 2: Export the Report and Filter by User

1. Click Export
   Select Export to Excel or Export to CSV in the top-right corner of the report page.
2. Open the CSV file
   Use Excel or a text editor to open the exported file. The file contains one row per user with columns for channel messages, replies, mentions, and call minutes.
3. Filter by group membership
   In Excel, use the Data > Filter option to show only the users in your security group. You can copy the list of group members from the Microsoft 365 admin center or from PowerShell.

Step 3: Confirm Group Membership and Licensing

1. Check group membership
   Go to Microsoft 365 admin center > Teams & groups > Active teams & groups > Security groups. Select your group and review the members list.
2. Verify licenses
   Each member must have a Teams license assigned. In the Microsoft 365 admin center, go to Users > Active users and check the Licenses and apps tab for each user.
3. Confirm sign-in
   Users must have signed into Teams at least once. If they have never launched Teams, they will not appear in the usage report.

If Teams Usage Report Still Shows Zero Activity

If the report still shows zero after checking the date range, filters, and membership, use one of these alternative methods to get the data.

Use the Microsoft 365 Admin Center Active Users Report

The Microsoft 365 admin center has a report that shows activity for all Microsoft 365 services, including Teams. This report supports a security group filter and can show aggregate activity for the group.

1. Open the Active Users report
   Go to Microsoft 365 admin center > Reports > Usage > Active users.
2. Select the Teams activity column
   Look for the column named Teams or Teams messages. This shows the number of active Teams users in the group.
3. Apply the group filter
   Click Filter and select your security group. The report will show aggregate activity for all members.

Use PowerShell to Get Per-User Teams Activity

You can use the Microsoft Graph PowerShell SDK to pull activity data for each user in the group. This method gives you full control over the date range and lets you aggregate the data yourself.

1. Install the Graph PowerShell module
   Run Install-Module Microsoft.Graph in an elevated PowerShell window.
2. Connect to Graph
   Run Connect-MgGraph -Scopes "Report.Read.All","Group.Read.All" and sign in with an admin account.
3. Get group members
   Run Get-MgGroupMember -GroupId "group-id" to list all members. Replace group-id with the object ID of your security group.
4. Get Teams activity for each user
   Run Get-MgReportTeamsUserActivityUserDetail -Period "D90" to get activity for the last 90 days. Then filter the output to match the group members.

Teams Admin Center Usage Report vs Microsoft 365 Active Users Report for Security Groups

Item	Teams Admin Center Usage Report	Microsoft 365 Active Users Report
Group filter	Filters the list of users shown, does not aggregate	Shows aggregate activity for the selected group
Data granularity	Per-user rows with detailed Teams actions	Per-user rows with a summary of active services
Date range	7, 30, 90, or 180 days	7, 30, 90, or 180 days
Export options	CSV or Excel	CSV or Excel
Best for	Deep dive into individual user actions	Quick overview of group-wide adoption

You can now get accurate activity data for any security group in Teams. Start by checking the date range and export the per-user report. If the report still shows zero, use the Microsoft 365 admin center Active Users report or the Graph API to verify the data. For a quick check, remember the keyboard shortcut Ctrl+F in Excel to search for a specific user in the exported CSV.