txt
What if you want to export this to a chart, perhaps using PowerGadgets? Chances are you would just
want to list the sizes of the largest mailboxes near the quota. To do this you modify the script above so that
rather than piping the data to the Format-Table cmdlet, you pipe the data to a Select-Object cmdlet.
Select-Object doesn ??™ t accept changing the label so you also have to remove the label on your converted
TotalItemSize value. Be sure to run this on a server that has the PowerGadgets client installed.
Add-PSSnapin PowerGadgets
get-MailboxStatistics | where-object
{???IssueWarning???,???ProhibitSend???,???MailboxDisable d???,???NoChecking??? -contains
$_.StorageLimitStatus} | sort-object TotalItemSize | select-object DisplayName,
@{expression={$_.TotalItemSize.Value.ToMB()}} |out-chart
You will get a chart very similar to the one in Figure 16 - 10 .
Figure 16-10
Part IV: Automating Administration
480
Why did I say similar to Figure 16 - 10 ? Well, to get this printed in the book I had to change the font sizes
and colors. If you were to run this, you would still get a nice looking chart. Of course, you could also
spend five minutes modifying the colors, sizes, and other formatting options to make it look just like you
want it to.
You can obtain more information about using PowerGadgets including a free trial of the software at
powergadgets.
Pages:
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667