All,

Having an issue with a script i am creating to grab vaules from Exchange and dump these to a html through out the script i am using a variable $target i keep getting null value expressions aplologies but i really cant figure it out also after some advice from experts.

here's the error.

You cannot call a method on a null-valued expression At D:\APPS\Report\Script\target3.ps1:960 char:99

I am currently looking at 2 bits of code i've found and modified basically i want to use the $target variable which will grab the server name and provide to the -server or -id field and provide a list of 20 mailboxes sorted by size in mb

$Biggest20 = get-mailboxserver -id $target | get-mailboxdatabase | Get-Mailbox -resultsize unlimited | Get-MailboxStatistics | sort-object -Property totalitemsize -des | select-object Displayname, @{Name="Total Size (MB)";expression={(get-mailboxstatistics $_).totalitemsize.value.toMB()}} -first 20


Get-MailboxStatistics -server $target | sort-object -Property totalitemsize -des | select-object Displayname, @{Name="Total Size (MB)";expression={(get-mailboxstatistics $_).totalitemsize.value.toMB()}} -first 20


Apart from the issue above which powershell command would be the best???


Thanks to all for assistance.

Just remove Get-Mailboxstatistics from Expression in Select-Object because the value is already carried to this cmdlet from pipeline. so it will be like this.

Get-MailboxStatistics -server $target | sort-object -Property totalitemsize -des | select-object Displayname, @{Name="Total Size (MB)";expression={$_.totalitemsize.value.toMB()}} -first 20

And since both will return same kind of results so use the second one because less number of queries to DC and MBx servers.

Thanks.

Worked like a charm thans :-)