Fetch last activity date in all Teams teams

Robin Couvreur 26 Reputation points

Hello everyone,

As a Teams administrator, I am looking for a way to monitor my Teams environment. For that purpose, I would like to fetch a list of all the teams with the last activity date (last message or last shared documents) in my environment.

If someone could help me, it could be great!

Thank you all in advance

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
6,734 questions
Microsoft Graph Groups API
Microsoft Graph Groups API
A Microsoft API that creates and manages different types of groups and group functionality.
204 questions
Microsoft Graph Teamwork API
Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
2,099 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Vasil Michev 71,626 Reputation points MVP

    The easy way is to fetch the Teams Usage report data via Graph: https://www.michev.info/Blog/Post/3805/at-long-last-teams-usage-reports-are-available-via-the-graph-api
    As the documentation is not published yet, I'm not certain at this point whether per-date queries will also be available (as in using the (date=2022-04-01) format), but the metadata document hints they should be.

    Other than that, you can Tony's activity report script: https://office365itpros.com/2022/03/14/microsoft-365-groups-teams-activity-report/