Object of type "Microsoft.PowerShell.Commands.Internal.Format.FormatEntryData" is not legal

Reply

Albert Widjaja Posted: 02-02-2011 6:34 PM

rated by 0 users

Hi Everyone,

I'd like to know why the formatting for this powershell doesn't work ?

[PS] C:\>Get-MailboxStatistics | sort-object -descending totalItemSize | ft -autosize DisplayName, @{expression={$_.totalitem
size.value.ToMB()};label=”Mailbox Size(MB)”}, itemcount, lastlogontime | Sort-Object Itemcount

out-lineoutput : Object of type "Microsoft.PowerShell.Commands.Internal.Format.FormatEntryData" is not legal or not in the correct sequence. This is likely caused by a user-specified "format-*" command which is conflicting with the default formatti
ng.

any pointer to correction would be greatly appreciated.

Thanks.

Reply

vstarmanv replied on 02-04-2011 6:33 PM

rated by 0 users

I think that  there is problem due to location

Format-* must locate last pipeline , so

before formating, sort 2 property and then formating

Get-MailboxStatistics -database testdb1 | sort-object -property `
  @{Expression="ItemCount";Descending=$true}, `
 @{Expression="totalItemSize";Descending=$false} `
| ft -autosize DisplayName, @{expression={$_.totalitemsize.value.ToMB()}; label="Mailbox Size(MB)"}, `
itemcount, lastlogontime

Reply

Albert Widjaja replied on 02-04-2011 8:03 PM

rated by 0 users

ahh, IC

thanks for the correction man :-)