{"id":195,"date":"2009-05-11T12:01:54","date_gmt":"2009-05-11T11:01:54","guid":{"rendered":"http:\/\/www.edwardsd.co.uk\/work\/?p=195"},"modified":"2019-07-25T20:14:16","modified_gmt":"2019-07-25T19:14:16","slug":"exchange-mailbox-permissions-using-powershell-command-line","status":"publish","type":"post","link":"https:\/\/www.edwardsd.co.uk\/work\/2009\/05\/exchange-mailbox-permissions-using-powershell-command-line\/","title":{"rendered":"Exchange 2007 | EMC Powershell"},"content":{"rendered":"

Open “Exchange Management Shell” <\/strong><\/p>\n

Shortcut refs to: <\/strong>(C:\\WINDOWS\\system32\\windowspowershell\\v1.0\\powershell.exe -PSConsoleFile “C:\\Program Files\\Microsoft\\Exchange Server\\bin\\exshell.psc1” -noexit -command “. ‘C:\\Program Files\\Microsoft\\Exchange Server\\bin\\Exchange.ps1′”)<\/p>\n

If this is not installed, look at the following article for installing Exchange: http:\/\/technet.microsoft.com\/en-us\/library\/bb123694(EXCHG.80).aspx<\/a><\/p>\n

Don’t get the Exchange Management Shell & Windows Powershell mixed up – for Windows Powershell see:<\/span><\/strong><\/p>\n

\n

Adding send as permissions to mailbox:<\/strong><\/p>\n

Add-ADPermission \"Mailbox\" -User \"Domain\\User\" -Extendedrights \"Send As\"<\/pre>\n
Adding full access permissions to mailbox:<\/strong><\/p>\n
Add-MailboxPermission \"Mailbox\" -User \"Trusted User\" -AccessRights FullAccess<\/pre>\n
Adding full access permissions to ALL<\/span> mailboxes:<\/strong><\/p>\n
Get-Mailboxdatabase | Add-AdPermission -User \"Username\" -AccessRights GenericAll<\/pre>\n
List all mailbox stores in size order:<\/strong><\/p>\n
Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label=\"TotalItemSize(MB)\";expression={$_.TotalItemSize.Value.ToMB()}},ItemCount<\/pre>\n
List all mailbox stores in size order (Export to CSV \/ on Desktop):<\/strong><\/p>\n
Get-MailboxStatistics -Database \u201cMailbox Database\u201d | Select DisplayName, LastLoggedOnUserAccount, ItemCount, TotalItemSize, LastLogonTime, LastLogoffTime | Export-CSV test.csv<\/pre>\n
List all mailbox stores in size order:<\/strong><\/p>\n
Get-MailboxStatistics -Database \u201cMailbox Database\u201d | Sort -Property TotalItemsize | Format-Table DisplayName, LastLoggedOnUserAccount, ItemCount, @{expression={$_.totalitemsize.value.ToMB()};label=\u201dSize(MB)\u201d}, LastLogonTime, LastLogoffTime<\/pre>\n
\n
Purge all disconnected mailboxes:<\/strong><\/p>\n
(Add all the disconnected mailboxes into a var by typing the below:)<\/p>\n
$users = Get-MailboxStatistics | where-object { $_.DisconnectDate -ne $null } | Select DisplayName,MailboxGuid,Database<\/pre>\n
Purge all the disconnected mailboxes in the previously made var by typing the below:<\/strong><\/p>\n
$users | ForEach { Remove-Mailbox -Database $_.Database -StoreMailboxIdentity $_.MailboxGuid -confirm:$false }<\/pre>\n
\n
List all Public folder email addresses (output to file)\u00a0<\/strong><\/p>\n
I had a request for all the email addresses associated to public mailboxes, as these are not displayed on the client in Outlook.<\/p>\n
Method1:<\/strong><\/p>\n
Displays a list of Public Folders & Email addresses output to TXT File (FL = Formats list with full text)<\/p>\n
Get-PublicFolder -Recurse | Get-MailPublicFolder | fl DisplayName,Emailaddresses > c:\\publicfolders_list.txt<\/pre>\nngg_shortcode_0_placeholder\n
Method2:<\/strong> Displays a list of Public Folders & Email addresses output to CSV File:<\/p>\n
# Export-CSV PowerShell Spreadsheet\r\nClear-Host\r\n$FilePath = \"c:\\publicfolders.csv\"\r\nGet-MailPublicFolder | Select-Object DisplayName -expand emailaddresses| Export-CSV $FilePath<\/pre>\nngg_shortcode_1_placeholder\n
\n
List Exchange 2007 Product Version<\/strong><\/p>\n
Get-ExchangeServer | fl name,edition,admindisplayversion<\/pre>\n
\n
List Exchange 2007 Database Size<\/strong><\/p>\n
Get-MailboxDatabase | foreach-object {add-member -inputobject $_ -membertype noteproperty -name mailboxdbsizeinGB -value ([math]::Round(([int64](get-wmiobject cim_datafile -computername $_.server -filter ('name=''' + $_.edbfilepath.pathname.replace(\"\\\",\"\\\\\") + '''')).filesize \/ 1GB),2)) -passthru} | Sort-Object mailboxdbsizeinGB -Descending | format-table identity,mailboxdbsizeinGB<\/pre>\n
\n
List Exchange 2007 GUID<\/strong><\/p>\n
Get-MailboxDatabase -Identity \"<server name>\\<storage group name>\\<database name>\" | Format-Table Name, GUID<\/pre>\n
\n
Public Folder Permissions via Powershell<\/strong><\/p>\n
Type the below, replacing ‘public folder name’ with your public folder name\/path and you must keep the \\ at the front of it and also replace ‘username’ with the username:<\/p>\n
Add-PublicFolderClientPermission -Identity \"\\public folder name\" -AccessRights Owner -User username<\/pre>\n
Owner can be replaced with the following roles:<\/strong><\/p>\n