troubleshooting Question

PowerShell: Adding ToGB to a script

Avatar of K B
K BFlag for United States of America asked on
Powershell.NET ProgrammingExchangeMicrosoft 365Active Directory
4 Comments1 Solution373 ViewsLast Modified:
I cannot seem to convert the SUM to GBs... where would that go?

$report = Get-MoveRequest -ResultSize 10| Get-MoveRequestStatistics | 
    Select-Object -Property @{n = "DatebaseName"; e = {$_.targetdatabase.name}}, totalmailboxsize
$report | Group-Object -Property DatebaseName | Select-Object -Property @{n = "DatebaseName"; e = {$_.Name}}, @{n = "Sum"; e = {($PSItem.group | Measure-Object -Property totalmailboxsize -sum).Sum}} |
    Sort-Object -Property Sum -Descending |
    Out-GridView -Title "Size Per Database"


Thank you
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros