Bit late to the party as they say but I see that for every Microsoft Teams that is created, it appears as a site collection within the SharePoint Admin Centre.
I use a migration tool named Sharegate which can be also be used for reporting. I run a report on all site collections. My question is how do I decipher what is a team vs what is a SharePoint site? the only thing that stands out is no Team has a subsite, so I filter on the Subsite field = 0 but are there any other indicators?
What does anyone else do when their company needs a report on all the Microsoft Teams that have been created over the years? Do you just export from admin centre? The issue I have with that is, it doesn't include who created them,
If you create a "team" in Microsoft teams, a SharePoint site and M365 group will be created with it. If you create a SharePoint team site with M365 group, a team in Microsoft teams will be created automatically.
Check these documentation to understand this in detail:
If you need reporting based on Microsoft teams, you can use PowerShell tools like PnP PowerShell, Microsoft Teams PowerShell or CLI for Microsoft 365. You can find few script sample related to this topic at:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.