SG list
Hello,I would need to know number of users that belong to Storage group --> Eg: SG01 = 16 UsersI need to get the result as a list and export it in a csv file.Can u please help me?
June 11th, 2009 10:59am

try this command Get-StorageGroup -Identity "mailbox server name\storage group name"| Get-MailboxDatabase | Get-Mailbox > C:\users.txt
Free Windows Admin Tool Kit Click here and download it now
June 11th, 2009 11:34am

I get an error message:Get-StorageGroup : Cannot bind parameter 'Identity'. Cannot convert value "mailbox server name\storage group name" to type "Microsoft.Exchange.Configuration.Tasks.StorageGroupIdParameter".At line:1 char:27 + Get-StorageGroup -Identity <<<< "mailbox server name\storage group name" | Get-MailboxDatabase | Get-Mailbox > c:\users.txt
June 11th, 2009 11:42am

replace "mailbox server name\storage group name" with your mailbox server name and storage group namelike thisGet-StorageGroup -Identity exchange\storagegroup2 | Get-MailboxDatabase | Get-Mailbox > c:\users.txt
Free Windows Admin Tool Kit Click here and download it now
June 11th, 2009 12:00pm

It should be per Mailbox Database instead of Storage Group... :) On Screen: Get-MailboxDatabase | Select Identity, @{Name="Number Of Mailboxes";expression={(Get-Mailbox -Database $_.Identity | Measure-Object).Count}} In CSV: Get-MailboxDatabase | Select Identity, @{Name="Number Of Mailboxes";expression={(Get-Mailbox -Database $_.Identity | Measure-Object).Count}} | Export-Csv DatabaseInfo.csv Similar Thread: http://social.technet.microsoft.com/Forums/en-US/exchangesvradmin/thread/4c959d59-62fb-46bb-8998-4c9f353e6556 Amit Tank | MVP Exchange Server | MCITP: EMA | MCSA: M | http://ExchangeShare.WordPress.com
June 11th, 2009 12:02pm

for storage group :)Get-MailboxDatabase | Select StorageGroup,@{Name="Number Of Mailboxes";expression={(Get-Mailbox -Database $_.Identity | Measure-Object).Count}}
Free Windows Admin Tool Kit Click here and download it now
June 11th, 2009 12:18pm

for storage group :)Get-MailboxDatabase | Select StorageGroup,@{Name="Number Of Mailboxes";expression={(Get-Mailbox -Database $_.Identity | Measure-Object).Count}} This will give just name of StorageGroup but number of mailboxes is for the mailbox database, isn't it? :)Amit Tank | MVP Exchange Server | MCITP: EMA | MCSA: M | http://ExchangeShare.WordPress.com
June 11th, 2009 12:21pm

Hello,I do get the list of SG but I do not have the numbers of users belongging to those SGs.Eg:SG01 = 16 usersSG02 = 5 usersSG03 = 56 usersWith the above commands I get:Identity--------Server01\SG01\VIPServer01\SG03\canadaServer01\SG04\ France StorageGroup------------Server01\SG01Server01\SG03Server01\SG04
Free Windows Admin Tool Kit Click here and download it now
June 11th, 2009 1:02pm

Do you get result on the screen? It works in my environment to display on screen as well as exporting in csv. Can you please post the exact cmdlet which you used?Amit Tank | MVP Exchange Server | MCITP: EMA | MCSA: M | http://ExchangeShare.WordPress.com
June 11th, 2009 2:49pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics