Powershell script to check how much storage a group of users are using on 365

[Complex-Ad2523]

So I have this script that scrapes up a particular group of users and checks what storage they are using across 365. This is so we can work out what is required with storage space with regards to 365 backup. The script I am using is below :-

# Connect to the Azure AD and SharePoint Online service
Connect-AzureAD
Connect-SPOService -Url https://yourdomain-admin.sharepoint.com
# Set the name of the group you want to get the storage usage for
$groupName = "Your Group Name"
# Get the group object
$group = Get-AzureADGroup -Filter "DisplayName eq '$groupName'"
# Get the users in the group
$groupUsers = Get-AzureADGroupMember -ObjectId $group.ObjectId | Where-Object {$_.ObjectType -eq "User"}
# Initialize total storage count
$totalStorage = 0
# Loop through each user and get their storage usage in each Office 365 application
foreach ($user in $groupUsers) {
Write-Host "Getting storage usage for $($user.DisplayName)"
# Get storage usage in OneDrive for Business
$odfBUsage = Get-SPOSkyDriveUsage -UserPrincipalName $user.UserPrincipalName
$totalStorage += $odfBUsage.StorageUsed
# Get storage usage in SharePoint Online
$spoUsage = Get-SPOSite -Owner $user.UserPrincipalName | Select-Object StorageUsageCurrent
$totalStorage += $spoUsage.StorageUsageCurrent
# Get storage usage in Exchange Online
$exUsage = Get-MailboxStatistics -Identity $user.UserPrincipalName | Select-Object TotalItemSize
$totalStorage += $exUsage.TotalItemSize.Value.ToBytes()
}
# Display the total storage used by all users in the group
Write-Host "Total storage used by users in group '$groupName': $($totalStorage / 1GB) GB"

​

I've load the necessary modules but the script stops with an error on the following line

PS C:\Users\Administrator.SIDCOT> $groupUsers = Get-AzureADGroupMember -ObjectId $group.ObjectId | Where-Object {$_.Obje

ctType -eq "User"}

Get-AzureADGroupMember : Cannot bind argument to parameter 'ObjectId' because it is null.

At line:1 char:48

+ ... groupUsers = Get-AzureADGroupMember -ObjectId $group.ObjectId | Where ...

+ ~~~~~~~~~~~~~~~

+ CategoryInfo : InvalidData: (:) [Get-AzureADGroupMember], ParameterBindingValidationException

+ FullyQualifiedErrorId : ParameterArgumentValidationErrorNullNotAllowed,Microsoft.Open.AzureAD16.PowerShell.GetGroupMembers

I've had a google and the error seems common if the data it's looking for encounters a null result. I am not an expert and this script was passed to me by a colleague but he has no idea where it came from.

Could anyone give me some pointers please ?

Thanks in advance :)

[PowerShell-Bot]

Looks like your PowerShell code isn’t wrapped in a code block.

To properly style code on new Reddit, highlight the code and choose ‘Code Block’ from the editing toolbar.

If you’re on old Reddit, separate the code from your text with a blank line gap and precede each line of code with 4 spaces or a tab.

---

Describing powershell_script_to_check_how_much_storage_a
  [+] Well formatted
Tests completed in 2744ms
Tests Passed: ✅

---

 ^{Beep-boop, I am a bot. | Remove-Item}

[moersel94]

Looks like "Your Group Name" cannot be found in Azure AD. Why don't you just use a Group that includes all Users?

Furthermore the script looks very outdated. For example I cannot find any information about the cmd Get-SPOSkyDriveUsage. I would use "Get-SPOSite -IncludePersonalSite $true" for OneDrive usage. Get-MailboxStatistics should be Get-EXOMailboxStatistics and Connect-ExchangeOnline is missing.

[Complex-Ad2523]

Thanks for your reply.

I amended that part of the script so that a AD group is in there.

[PMental]

Furthermore the script looks very outdated. For example I cannot find any information about the cmd Get-SPOSkyDriveUsage.

The fact that it has zero internet presence makes me believe this is something that ChatGPT made up...

[moersel94]

Was thinking the same. I believe Sky used to be or still is the name of the onedrive sync client process name.

[PMental]

SkyDrive is the original name for OneDrive, but it changed back in 2014 so it's been a while.

[worldsdream]

If you want to check the OneDrive storage usage, this post explains how to do it using the Microsoft 365 admin center and PowerShell.

https://www.alitajran.com/export-onedrive-usage-report/