Gather Microsoft Teams Statistics using Graph API

This script uses Graph API to gather statistics regarding Microsoft Teams.


IMPORTANT:

• You will need to have, or create, an 'app registration' in Azure and create a 'client secret';
• The app registration will need the following API permissions to Graph API: 'Group.Read.All' and 'User.Read.All', both of type 'Application'.

The script gathers and exports the following stats for each team:

• Team: the display name of the team;
• Description: the team's description as set by its owner;
• Email: the team's email address;
• CreatedOn: the date and time the team was created;
• RenewedOn: the date and time when the team was renewed;
• Visibility: if the team is 'Private' or 'Public';
• Owners: the number of owners;
• OwnerNames: the display name of all the team's owners;
• Members: the number of members;
• Channels: the number of channels for the team;
• ChannelNames: the display name of all the team's channels.

To call the script, simply run:

.\GetTeamsDetails.ps1