Powershell format-table or select-object only show top results

sorting powershell formatting exchange-server-2007
Schuyler picture Schuyler · Dec 4, 2013 · Viewed 10.1k times · Source

I am trying to find users that have been sending the most emails. But in the end I only want to display the top 10 (or n number) of senders. Is there a way to only show the top results using select-object or format-table

$Messages = Get-ExchangeServer * | where{$_.ServerRole -eq "HubTransport"} | %{get-messagetrackinglog -server $_.name -EventID "SEND" -Start (get-date -format G).AddDays(-1) -ResultSize unlimited}) 2>&1 | out-null

$messages | where{$_.sender -like "*@OurDomain.com*"} | select sender | group sender | sort count -Descending | ft count,name

Is there a way to make this only display the top results?

The only way I can think of would be storing them in a variable and outputting them in a for loop

Answer

Eris picture Eris · Dec 4, 2013

Before the ft, add:

select -first 10

Replacing the 10 with how many you want.

So the full command would be:

$messages | where{$_.sender -like "*@OurDomain.com*"} | select sender | group sender | sort count -Descending | select -first 10 | ft count,name

Related questions

Hashtables and key order

Is there a way to keep the order of keys in a hashtable as they were added? Like a push/pop mechanism. Example: $hashtable = @{} $hashtable.Add("Switzerland", "Bern") $hashtable.Add("Spain", "Madrid") $hashtable.Add("Italy", "Rome") $hashtable.Add("Germany", "Berlin") $…

Read More
Count, Sort and Group-By in Powershell

Are there any cool cmdlets that will help me do the following? I want something in Powershell that is as simple as doing the same in SQL: select RootElementName , count(*) from Table group by RootElementName order by RootElementName I'm all …

Read More
How do I sort a dictionary by value?

I have a dictionary of values read from two fields in a database: a string field and a numeric field. The string field is unique, so that is the key of the dictionary. I can sort on the keys, but …

Read More