Microsoft teams size

Question

Microsoft teams size

HASSAN BIN NASIR DAR 391

Hi

I have more than 300 microsoft teams. I want to know the size of all teams (I mean, individually teams size). Is there any powershell command?

Kael Yao 37,746 Reputation points Moderator

2022-09-16T05:11:53.323+00:00

Hi @HASSAN BIN NASIR DAR

Sorry not sure I understand your question.
Do you mean you would like to get the member counts for each team?

3 answers

Your answer

Kael Yao 37,746 Reputation points Moderator

2022-09-16T05:11:53.323+00:00

Hi @HASSAN BIN NASIR DAR

Sorry not sure I understand your question.
Do you mean you would like to get the member counts for each team?

Answer 1

Hi @HASSAN BIN NASIR DAR
We can use the SharePoint Online Powershell cmdlet Get-SPOSite to get current site storage size and storage quota. Before proceeding, run the following command to connect Sharepoint Online Powershell module.

Connect-SPOService -Url https://<tanentname>-admin.sharepoint.com -Credential ******@o365domain.com

Now run the below script after replacing the <tanentname> and <group-name> with your own tenant name and group name.

$O365GroupSiteUrl ="https://<tanentname>.sharepoint.com/sites/<group-name>"  
$O365GroupSite = Get-SPOSite -Identity $O365GroupSiteUrl  
$StorageSize =$O365GroupSite.StorageUsageCurrent  
Write-Host "Storage  used (MB): " $StorageSize " MB" -ForegroundColor Yellow  
Write-Host "Storage  used (GB): " ($StorageSize/1024) " GB" -ForegroundColor Yellow

Get the current Storage Size for all Office 365 Groups:

$userName ="admin@<tanentname>.onmicrosoft.com"  
$o365Cred = Get-Credential -UserName $userName -Message "Enter Office 365 Admin Credentials"  
$o365Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $o365Cred -Authentication Basic -AllowRedirection  
Import-PSSession $o365Session  
$spoAdminUrl ="https://<tanentname>-admin.sharepoint.com/"  
Connect-SPOService -Url $spoAdminUrl -Credential $o365Cred  
$O365Groups = Get-UnifiedGroup -ResultSize Unlimited  
$CustomResult=@()  
ForEach ($O365Group in $O365Groups){  
If($O365Group.SharePointSiteUrl -ne $null) { $O365GroupSite=Get-SPOSite -Identity $O365Group.SharePointSiteUrl  
$CustomResult += [PSCustomObject] @{  
GroupName =  $O365Group.DisplayName  
SiteUrl = $O365GroupSite.Url  
StorageUsed_inMB = $O365GroupSite.StorageUsageCurrent  
StorageQuota_inGB = $O365GroupSite.StorageQuota/1024  
WarningSize_inGB =  $O365GroupSite.StorageQuotaWarningLevel/1024  
}  
}}  
$CustomResult | FT

You can also export the output into CSV file:

$CustomResult | Export-CSV "C:\\O365-Group-Storage-Info.csv" -NoTypeInformation -Encoding UTF8

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

RaytheonXie_MSFT 40,471 Reputation points Microsoft External Staff

2022-09-22T09:38:19.923+00:00

Hi @HASSAN BIN NASIR DAR
Have you tried the solution I proposed?

If you have any questions or progress, you can contact me in time.

Looking forward to your reply

Have a lucky day!

Thanks,
Raytheon Xie
RaytheonXie_MSFT 40,471 Reputation points Microsoft External Staff

2022-09-29T08:23:08.587+00:00

Hi @HASSAN BIN NASIR DAR
Do you mean 360 groups under the tenant? The script could export storage size for all Office 365 Groups under the tanant.

Answer 2

Filip Neshev 1

First run:
$Teamsgroups = Get-UnifiedGroup -Filter "ResourceProvisioningOptions -eq 'Team' "
to find all existing Teams.

Next run:
$Teamsgroups | select DisplayName, @{L=’Number of Members’; E={ ( Get-TeamUser -GroupId $_.ExternalDirectoryObjectId ).count } }

Prerequisites:

Add-PSSnapin Microsoft.Exchange.Management.PowerShell.SnapIn ( for Get-UnifiedGroup )
Install module MicrosoftTeams ( for Get-TeamUser )

Jeff Mason at Sovereign Sportsman Solutions 0 Reputation points

2023-08-08T14:42:19.26+00:00
This does not produce any value under "Number of Members". Also, the pre-reqs are very vague. Under PowerShell 5.1, I was able to do the following and didn't need to do "Add-PSSnapin" nor any specific "Teams" module:

1. Install-Module AzureAD If needed, if you have the module already installed & there's a newer AzureAD module Install-Module -Name AzureAD -Force 2. Import-Module AzureAD 3. Connect-AzureAD Above makes the general AzureAD admin connection; use your admin creds 4. Install-Module -Name ExchangeOnlineManagement The above Exchange Online modules are needed for some functions 5. Connect-ExchangeOnline Above makes the general Exchange admin connection; use your admin creds

So, I'm wondering if this portion "@{L=’Number of Members’; E={ ( Get-TeamUser -GroupId $_.ExternalDirectoryObjectId ).count } }" may be flawed? Also, an "FT" (format-table) likely is needed, in order to make more readable output. Update: I did find that the "single-quotes" did not copy properly around "Number of Members," and I corrected that, but still it made no difference.

Answer 3

HASSAN BIN NASIR DAR 391

Hi,

I am going to migrate my all Microsoft teams sites from one Microsoft 365 tenant to other 365 tenant. I want to know the size of all teams sites because I want to calculate estimate time how long time my migration software will take.

Regards

Share via

Microsoft teams size

3 answers

Your answer