syntax

rogerroger3 · 2018-05-07T14:37:42.000Z

I want to export csv for all users in office 365 with their dumpster size above 50GB. i have exchange on premises and exchange online, i want to export for exchange online. plz guide me with the syntax, the below syntax works for all users but i want to export the report for dumpster size above 50GB.

with below syntax i am not able to import properly into csv, usernames are not being imported . i tried below

script1.ps1 | export-csv c:\mydumster.csv -notypeinformation
script1.ps1 | out-file c:\mydumster.csv

$AllMailboxes = Get-Mailbox -ResultSize unlimited
ForEach ($Mailbox in $AllMailboxes){
Write-Host “Dumpster size for $Mailbox” -ForegroundColor Green
Get-MailboxFolderStatistics -Identity $mailbox.alias -FolderScope recoverableitems | select Name,FolderAndSubfolderSize,ItemsInFolderAndSubfolders
}

rogerroger3 · 2018-05-08T16:49:46.000Z

hi experts help required on this

i want to pull report for all the users having dumpster size above 50GB

DoctorDNS · 2018-05-08T18:20:21.000Z

Since this is really a PowerShell question - I’ll add that group to this post!

Neally · 2018-05-08T18:28:08.000Z

Roger, If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

Neally · 2018-05-08T18:40:34.000Z

maybe something like so

Get-MailboxFolderStatistics $MailBoxName -FolderScope recoverableitems |
select folderandsubfoldersize |
where folderandsubfoldersize -gt 50GB

rogerroger3 · 2018-05-09T15:54:32.000Z

I tried below syntax but i am getting error

PS C:\Windows\system32> Get-Mailbox -ResultSize Unlimited | Foreach{Get-MailboxFolderStatistics $_ -FolderScope RecoverableItems | Where{$_.FolderAndSubFolderSize -gt 50Gb} | Select Identity,folderandsubfoldersize}| export-csv “c:\report.csv” -notypeinformation

for every user i am getting the below error when i execute in shell

Cannot process argument transformation on parameter ‘Identity’. Cannot convert value “my user” to type"Microsoft.Exchange.Configuration.Tasks.GeneralMailboxOrMailUserIdParameter". Error: “Cannot convert hashtable to anobject of the following type: Microsoft.Exchange.Configuration.Tasks.GeneralMailboxOrMailUserIdParameter.
Hashtable-to-Object conversion is not supported in restricted language mode or a Data section.”

CategoryInfo : InvalidData: ( [Get-MailboxFolderStatistics], ParameterBindin…mationException
FullyQualifiedErrorId : ParameterArgumentTransformationError,Get-MailboxFolderStatistics
PSComputerName : outlook.office365.com