A little confused, so i want to retreive all mailboxes and output them to an array which is working fine code below $MBDatabases = Get-MailboxDatabase | where {$_.name -like "*EU*"} | select name $outarray = @() foreach ($MBDatabase in $MBDatabases) { $Users = Get-MailboxStatistics -Databas…

for each MailBoxStatistic object you easily can get mailbox or user with Get-Mailbox -Identity $user.LegacyDN Get-User -Identity $user.LegacyDN and do something like # [...] $Users = Get-MailboxStatistics -Database $MBDatabase.name | where {$_.ObjectClass -eq “Mailbox”} foreach ($user in $users)…

Much appreciated Max, will give this a shot first thing tomorrow

Hi Max gave this a shot today, but it reports the last line in wrong $MBDatabases = Get-MailboxDatabase | where {$_.name -like "*EU*"} | select name foreach ($MBDatabase in $MBDatabases) { $Users = Get-MailboxStatistics -Database $MBDatabase.name | where {$_.ObjectClass -eq “Mailbox”} …

sorry, I’m misinform you this way works $output = foreach ($MBDatabase in $MBDatabases) { # [...] } $output | Out-GridView

Thanks max, just another quick Q out of interest whats the benefit of this over adding objects to an array ?

Hey Mark, Both methods result in an array. Example $numlist = 1..10 $addarray = @() $returnedarray = foreach ($num in $numlist) { $psobj = [pscustomobject]@{ num = $num } $addarray += $psobj $psobj } In the above example we are using both methods. One to add the custom PS…

In addition to @Curtis explanation “+=” also memory expensive for array with 10000 elements after “$array += 1” you have two arrays in memory: named $array with 10001 element and unnamed (old) with 10000 elements it falls under GarbageCollection after that but still exists some time…

Thanks both, have a much better understanding now

Where am i going wrong ? Psobject & Foreach

PowerShell Help

Topic		Replies	Views
PS Object data help PowerShell Help	5	195	May 16, 2024
Combining two psobject tables(arrays) into one PowerShell Help	9	300	May 16, 2024
Create custom table for showing results PowerShell Help	1	210	May 16, 2024
PS Foreach-Object Get the Object PowerShell Help	6	308	May 16, 2024
Making The Code Neater PowerShell Help	7	221	May 16, 2024

Where am i going wrong ? Psobject & Foreach

Related topics