Teams reports

How many teams exist and how much they are used. Both come from the Graph reports API and are useful for a Teams governance or cleanup exercise.

flowchart LR
    A["get_teams_team_counts"] --> A1["Public / private teams, how many active"]
    B["get_teams_user_activity_user_counts"] --> B1["Users: chats, calls, meetings"]

Teams usage

Team counts by visibility with the active-vs-total split, plus unique users per activity type (team chat messages, private chat messages, calls, meetings).

teams = client.reports.get_teams_team_counts("D30").execute_query().csv_rows()
users = client.reports.get_teams_user_activity_user_counts("D30").execute_query().csv_rows()

A period with no Teams activity is normal in a small tenant; the script prints that instead of an empty table.

Needs the Reports.Read.All application permission.