Some Exchange 2007 CMDlets

-
Mailbox Size Report - Individual Database

cls
Get-MailboxStatistics -Database "ecgcmail01\webmail users\mailboxes" | Sort-Object TotalItemsize -Descending | Where {$_.TotalItemSize -gt 145MB} | ft Displayname , @{expression={$_.TotalItemSize.Value.ToMB()}}, StorageLimitStatus

Get-MailboxStatistics -Database "ecgcmail01\general users\mailboxes" | Sort-Object TotalItemsize -Descending | Where {$_.TotalItemSize -gt 65MB} | ft Displayname , @{expression={$_.TotalItemSize.Value.ToMB()}}, StorageLimitStatus

*******************************

update 10K Photo in AD

Import-RecipientDataProperty -Identity "Bharat Suneja" -Picture -FileData ([Byte[]]$(Get-Content -Path "C:\pictures\BharatSuneja.jpg" -Encoding Byte -ReadCount 0))

**************************************

Enable OWA for list of users

$path = "d:\Andy\Owa.txt"
foreach ($line in Get-Content $path) { Set-CASMailbox –Identity $line –OWAEnabled:$true }

**********************************************
Logon Statastics Report

Get-LogonStatistics -Server "ecgcmail01" | Sort-Object Logontime –Descending | ft userName , Logontime

*******************************
List of Databases

Get-Mailbox -Database "ecgcmail01\general users\mailboxes" |Sort-Object Name –Descending

*******************************
Move all Mailboxes from database

Get-Mailbox -Database "ecgcmail01\ecgc users\general user" |Move-Mailbox -TargetDatabase "ecgcmail01\general users\mailboxes" -PreserveMailboxSizeLimit

*******************************
List Group Members

Get-QADGroupMember -Identity ITCoordinators

*******************************
For Logon Details

$last30d = (Get-Date).Subtract((New-TimeSpan -Days 15))
get-mailboxstatistics -Server ecgcmail01 | where {$_.lastlogontime -lt $last30d} | Ft Displayname , lastlogontime

*******************************
Add User to Group

Add-QADMemberOf -Group "Internet users" -Identity "ecgcindia\sukhan.singh"

*******************************
Get all disconnected mailboxes

Get-MailboxStatistics | where-object { $_.DisconnectDate -ne $null } | Select DisplayName,MailboxGuid

*******************************
Remove a single disconnected mailbox

Remove-Mailbox -Database <Database-Name> -StoreMailboxIdentity <MailboxGuid> -confirm:$false

*******************************
Remove all disconnected mailboxes

$users = Get-MailboxStatistics | where-object { $_.DisconnectDate -ne $null } | Select DisplayName,MailboxGuid,Database

*******************************
Update GAL

Update-GlobalAddressList  -identity "Default Global Address List"

*******************************
Certificate Request

New-ExchangeCertificate -GenerateRequest -Path c:\webmail_ecgc_in.csr -KeySize 1024 -SubjectName "c=IN, s=Maharashtra, l=Mumbai, o=Export Credit Guarantee Corporation of India, ou=MAIL SERVER, cn=webmail.ecgc.in" -DomainName ecgcindia.com, ecgcowa01.ecgcindia.com, ecgcmail01.ecgcindia.com, webmail.ecgc.in, autodiscover.ecgcindia.com, autodiscover.ecgc.in, ecgc.in -PrivateKeyExportable $True

*******************************
Enable Disable Outlook Anywhere Access
set-casmailbox -mapiblockoutlookrpcthhp:$true

you can do:
get-user | set-casmailbox -mapiblockoutlookrpcthhp:$true
which will kill all access, and then go back and to a $false for the two in question to allow them to use it.

*******************************

To Create CAS Virtual directories using Exchange PowerShell

Get-OwaVirtualDirectory -server ecgcowa01 | Remove-OwaVirtualDirectory
New-OwaVirtualDirectory -Name "Exchange" -owaversion Exchange2003or2000 -VirtualDirectoryType Mailboxes -WebSiteName "Default Web Site"
New-OwaVirtualDirectory -Name "exadmin" -owaversion Exchange2003or2000 -VirtualDirectoryType exadmin -WebSiteName "Default Web Site"
New-OwaVirtualDirectory -Name "public" -owaversion Exchange2003or2000 -VirtualDirectoryType PublicFolders -WebSiteName "Default Web Site"
New-OwaVirtualDirectory -Name "owa" -owaversion Exchange2007 -WebSiteName "Default Web Site"
New-OwaVirtualDirectory -Name "exchweb" -owaversion Exchange2003or2000 -VirtualDirectoryType exchweb -WebSiteName "Default Web Site"

*******************************
Move Mailbox

Move-Mailbox -TargetDatabase "ecgcmail01\ECGC Users\webmail user" -Identity "ED" -preservemailboxsizelimit
Y
*******************************
Export Mailbox in PST

Export-Mailbox -pstfolderpath d:\andy\pst\ -identity "Ashok Dichwalkar"
Y
*******************************
cls
Get-MailboxStatistics -Database "ecgcmail01\general users\mailboxes" | Sort-Object TotalItemsize -Descending | Where {$_.TotalItemSize -gt 65MB} | ft Displayname , TotalItemSize
Get-MailboxStatistics -Database "ecgcmail01\webmail users\mailboxes" | Sort-Object TotalItemsize -Descending | Where {$_.TotalItemSize -gt 145MB} | ft Displayname , TotalItemSize

Comments

Post a Comment

Popular posts from this blog

Script to remove domain user from local administrator group

-
' (This script can run as logon script without problems because it first check if the user is a member. ' If the user is a local administrator s/he has privileges to remove him/her self from the local group. ' Do Keep in mind however that the user at this stage already is logged-on as an Administrator, ' s/he will keep all the access rights until the next logon). Set objNetwork = CreateObject("Wscript.Network") strUser = objNetwork.UserName strDomain = objNetwork.UserDomain strComputer = objNetwork.ComputerName strLocalGroup = "Administrators" On Error Resume Next ' Bind to local group object. Set objGroup = GetObject("WinNT://" _ & strComputer & "/" & strLocalGroup & ",group") If (Err.Number 0) Then wscript.Quit ' Bind to the user object on the Domain. ' (use also the WinNT provider). Set objUser = GetObject("WinNT://" _ & strDomain & "/" ...
Read more

Windows Service monitoring and mail reporting Scripts

-
Create following two files and modify accordingly as per your requirement. Create a scheduled batch file to execute. File name Service Test.bat Set Location as C:\ --------- c:\ date /t >C:\PortsReport.txt time /t >>C:\PortsReport.txt portQry -n Server name -e 25 >>C:\PortsReport.txt portQry -n Server name -e 110 >>C:\PortsReport.txt portQry -n Server name -e 80 >>C:\PortsReport.txt set /A STATUS = 0For /F " eol=; delims=: tokens=3" %%I in (' Find /I /C "NOT LISTENING"C:\PortsReport.txt') Do Set status=%%I if /I %STATUS% gtr 0 cscript C:\Errormail.vbs ----- File Name ErrorMail.vbs Set Location as C:\ ---- Set objMessage = CreateObject("CDO.Message") objMessage.Subject = "Server Protocol Status Report" objMessage.From = "" objMessage.To = "" objMessage।TextBody = "" objMessage.AddAttachment "C:\PortsReport.txt" objMessage.Configuration.Fields.Item _(" http://schemas.mi...
Read more

Exchange 2007 Powershell

-
Mailbox Size Report - Individual Database cls Get-MailboxStatistics -Database "ecgcmail01\webmail users\mailboxes" | Sort-Object TotalItemsize -Descending | Where {$_.TotalItemSize -gt 145MB} | ft Displayname , @{expression={$_.TotalItemSize.Value.ToMB()}}, StorageLimitStatus Get-MailboxStatistics -Database "ecgcmail01\general users\mailboxes" | Sort-Object TotalItemsize -Descending | Where {$_.TotalItemSize -gt 65MB} | ft Displayname , @{expression={$_.TotalItemSize.Value.ToMB()}}, StorageLimitStatus ******************************* update 10K Photo in AD Import-RecipientDataProperty -Identity "Bharat Suneja" -Picture -FileData ([Byte[]]$(Get-Content -Path "C:\pictures\BharatSuneja.jpg" -Encoding Byte -ReadCount 0)) ************************************** Enable OWA for list of users $path = “d:\Andy\Owa.txt” foreach ($line in Get-Content $path) { Set-CASMailbox –Identity $line –OWAEnabled:$true } ******************************...
Read more