In Part 1 of this post i demonstrated how to list all external team members with team owners and team name. Although this returned the data that we want. it doesn’t present it in a format that is easy to read and work with.
In this post i will show you how to get this data in a clear format where you can export it to PDF, CSV or just copy it to your clipboard.
This is what the data will look like at the end.
After researching some other blogs and coming across the wonderful “out-htmlview”. And coming across this post by Alexander. I was able to finally achieve a report that is comprehensive, tidy and informative.
The Source Code
I hope that this can prove useful!
And, im actually really interested in hearing from people who are better than me with powershell on how you would do things differently and improve the speed of this script!
If you are looking for guidelines on how you should govern teams in your organisation take a look at my post on Microsoft Teams Governance!
Thanks for reading!