How to generate Microsoft Teams basic Report for Office 365

In today’s blog you will learn about PowerShell scripting on How to generate Microsoft Teams basic Report for Office 365. In my last blog I discussed about adding bulk users from CSV file to Microsoft Teams using PowerShell and also how we can connect to teams. So I will skip connecting to the teams part and directly jump to main subject.

As you know most of the times as an administrator we need to generate reports related to Teams in our environment or tenant. Manager can ask you about number of users and their roles in a team. I developed a PowerShell script to extract basic information associated with users in a team in a csv file.

Script is given below.

##This script will be used to generate CSV report file related to MS Teams of an organisation.##Pre-requisite: Connect to Microsoft Teams Powershell & Exchange Online Powershell for this to work.##Link for MS Team: https://docs.microsoft.com/en-us/powershell/teams/?view=teams-ps##Link for Exchange online: https://docs.microsoft.com/en-us/powershell/exchange/exchange-online/connect-to-exchange-online-powershell/connect-to-exchange-online-powershell?view=exchange-ps##Version: 1.0##Date: 15-04-2020##Author: Rakesh Pandey

For more details on PowerShell commands related to MS teams, click on this link.

I hope you enjoyed this post on How to generate Microsoft Teams basic Report for Office 365. If yes, please share this article and subscribe to our web site for more stuff on Microsoft Teams. Also very soon we will release a tutorial for Microsoft Teams end users, stay tuned with us.

Rakesh is a Solution Architect having 11 years experience in banking domain designing enterprise level applications on Microsoft technologies. He has strong experience working on Azure, SharePoint, PowerApps & Flow.