MailboxDatabase groupby StorageGroup and sort by Name
Hi,
I would like to list my database name sort by name and group by storagegroup.
I tried this :
[PS] C:\Windows\System32>Get-MailboxDatabase | sort Name | group StorageGroup
4 SRV\First Storage ... {CA4, CA5, DIFF, IT}
3 SRV\Second Storage... {FR, NL, UK}
But I would like this :
CA4
CA5
DIFF
IT
FR
NL
UK
Thanks
DS
October 15th, 2010 7:44pm
On Fri, 15 Oct 2010 23:43:06 +0000, sidavid wrote:
>Hi, I would like to list my database name sort by name and group by storagegroup. I tried this : [PS] C:\Windows\System32>Get-MailboxDatabase | sort Name | group StorageGroup 4 SRV\First Storage ... {CA4, CA5, DIFF, IT} 3 SRV\Second Storage... {FR, NL,
UK} But I would like this : CA4 CA5 DIFF IT FR NL UK Thanks DS
How about this, instead?
Get-MailboxDatabase | sort storagegroupname,Name | select
storagegroupname,name
---
Rich Matheisen
MCSE+I, Exchange MVP
--- Rich Matheisen MCSE+I, Exchange MVP
Free Windows Admin Tool Kit Click here and download it now
October 15th, 2010 8:05pm
Thanks Perfect
October 15th, 2010 8:17pm