###########################################################################
# NAME: Delegates Report for Exchange Server 2010/2013
# AUTHOR: Rajkumar
# VERSION HISTORY:1.0 7/1/2013 - Initial release
###########################################################################
$ErrorActionPreference = "SilentlyContinue"
$WarningPreference = "SilentlyContinue"
$MailboxUsers = get-mailboxdatabase | get-mailbox -resultsize Unlimited | sort displayname
$Output=@();
# Perform a set of actions against each mailbox - Loop
foreach ($user in $MailboxUsers)
{
$Name = $user.Alias
$OutputItem = New-Object Object;
$delegates = Get-MailboxCalendarsettings $name |where {$_.resourcedelegates -notlike “”}
$delegateNames = $delegates.ResourceDelegates | ForEach { $_.Name }
$delegateString = $delegateNames -Join ", "
# Get the desired Ouputs
$OutputItem | Add-Member NoteProperty Alias $user.alias;
$OutputItem | Add-Member NoteProperty "Display Name" $user.name;
$OutputItem | Add-Member NoteProperty "PrimarySMTPAddress" $user.PrimarySMTPAddress;
$OutputItem | Add-Member NoteProperty "Delegates" $DelegateString;
# Add the object to our array of output objects
$Output += $OutputItem;
# Export the output as CSV File
$Output | Export-CSV -Path "C:\Mailboxreport.csv" -NoTypeInformation
$ToAddress = "Rajkumar.MCITP@Outlook.com"
$FromAddress = "ExchangeAdmin@DomainName.com"
$Body = "Please find the attached Delegates report for Company Name"
$attachments = "C:\Temp\DelegatesReport.csv"
send-mailmessage -to $ToAddress -from $FromAddress -subject "Delegates Reports" -smtpserver ServerName.Domain.local -attachments $attachments -body $body
$password = Read-Host "Enter password" -AsSecureString New-Mailbox -UserPrincipalName Name@DomainName.in -Alias AliasName -Database "Database Name" -Name 'Name' -OrganizationalUnit Users -Password $password -FirstName FirstName -LastName Last Name -DisplayName "Display Name" -ResetPasswordOnNextLogon $true
Set-Mailbox -Identity "Mailbox Name" -ForwardingSMTPAddress "EmailAddress@DomainName.com"Please note that, above shell command will forward all the emails to the Forwarding SMTP Address and no emails will deliver to concerned Mailbox To set the forwarding option to deliver the email to mailbox and to the forwarding SMTP address use the below shell command
Set-Mailbox -Identity "Mailbox Name" -ForwardingSMTPAddress "EmailAddress@DomainName.com" -DeliverToMailboxAndForward $True
Set-Mailbox -Identity "Mailbox Name" -RecipientLimits 10Before setting the limit, you can check the existing configuration using
Get-Mailbox -Identity "Mailbox Name" | FL Name, RecipientLimits
Set-Mailbox -Identity "Mailbox Name" -HideFromAddressListsEnabled $TrueTo disable the Hide from Address List option
Set-Mailbox -Identity "Mailbox Name" -HideFromAddressListsEnabled $False
Set-Mailbox -Identity "Mailbox Name" -Password (ConvertTo-SecureString -String "NewPassword" -AsPlainText -Force)and to reset the password on next logon
Set-Mailbox -Identity "Mailbox Name" -Password (ConvertTo-SecureString -String "NewPassword" -AsPlainText -Force) -ResetPasswordOnNextLogon $True
Get-Mailbox -Identity "Mailbox Name" | FL Name, Max*
Set-Mailbox -Identity "Mailbox Name" -UseDatabaseQuotaDefaults $false -IssueWarningQuota 102400 -ProhibitSendQuota 104800 -ProhitSendReceiveQuota 204800Values entered above as a limit is in KB
Get-Mailbox -Identity "Mailbox Name" | Fl Name, UseDatabaseQuotaDefaultsIf the UseDatabaseQuotaDefaults parameter is set to True then the Mailbox limits settings are inherited from the Database level settings, if it is set to false the use the below the shell command to find the quotas
Get-Mailbox -Identity "Mailbox Name" | Fl Name, UseDatabaseQuotaDefaults, ProhibitSendQuota, ProhibitSendReceiveQuota, IssueWarningQuotaAbove Commands can be used in Exchange 2010 Exchange Server 2013 and Office 365
Get-Mailbox -Idenity "Mailbox Name" -Archive | flTo view the Remote Archive Mailbox information, use the below shell command
Get-Mailbox -Idenity "Mailbox@DomainName.com" -RemoteArchive | fl
Get-ExchangeServer | FT Name, *Version*To find the roll up version number
GCM ExSetup | %{$_.FileVersionInfo}Get-MailboxPermission -Identity "Mailbox Name"| where { ($_.AccessRights -like "*FullAccess*") -and ($_.IsInherited -eq $false) -and -not ($_.User -like "NT AUTHORITY\SELF") } | Select User
Get-Mailbox -ResultSize unlimited | Get-MailboxStatistics | Select Displayname, ServerName, DatabaseName,TotalItemsize,IsArchivedMailbox, StorageLimitStatus, MailboxGuid, LastloggedOnUserAccount, LastLOgonTime |Export-csv C:\temp\MailboxStats.csvUsing the above shell command will allow you to export the Mailbox Statistics details as a CSV file and the Output will looks as shown below
Get-Queue -Identity "ServerName\QueueName" | FL Identity, MessageCount, NextHopDomain, LastError, LastRetryTime, NextRetryTimeQueue viewer will show the output on why the emails are in queue, you can check the reason from the LASTERROR parameter Below a sample output of the above shell command. Above shell command can be used in Exchange Server 2010 and Exchange Server 2013
Get-Queue -Server "Hub Transport Server Name"and to view the emails in all the Hub Transport Servers
Get-TransportServer | Get-Queue
Get-MailboxDatabaseCopyStatus -Server "Active Server Name"
Get-MailboxDatabaseCopyStatus -Server "Passive Server Name"
Get-MailboxDatabase -ResultSize Unlimted -Status | FT Name, MountedHow the Database mount status on the particular server
Get-MailboxDatabase -Server "Server Name" | FT Name, MountedHow to find database mount status of a particular database
Get-MailboxDatabase "Database Name" | FT Name, MountedYou can use the above shell commands in Exchange Server 2010 and Exchange Server 2013
Add-AdPermission -Identity "MailboxName" -User "User who needs Permission" -ExtendedRights Send-As -AccessRights "ReadProperty", "WriteProperty"
Add-MailboxPermission -Identity MailboxName -User "User Who Needs Permission" -AccessRights FullAccess
(Get-Mailbox -ResultSize Unlimited -Database "Database Name").countHow to get the Mailbox count in a Server
(Get-Mailbox -ResultSize Unlimited -Server "Server Name").countHow to get the Mailbox Count from the whole organization
(Get-Mailbox -ResultSize Unlimited ).countOk, I got the total count, now are you searching for option on how to get the room mailbox count?
(Get-Mailbox -ResultSize Unlimited -filter (RecipientTypeDetails -Eq "RoomMailbox")).countHow to calculate the Mailbox count which includes the disabled mailboxes in the database
(Get-MailboxStatistics -Database "Database Name").countHope its useful for you. Leave your comments if any details required.
Get-MessageTrackingLog -ResultSize unlimited -Sender “Sender@emailaddress.com” –Recipient “Recipient@emailaddress.com” -Start "MM/DD/YYYY 00:00:00" -End "MM/DD/YYYY 23:59:00"|Select Timestamp, EventId, Source, SourceContext, MessageID, MessageSubject, Sender,{$_.Recipients}, InternalMessageID, ClientIP, ClientHostName, ServerIp, ServerHostName, ConnectorID,{$_.RecipientStatus},TotalBytes,RecipientCount,RelatedRecipients,Reference, ReturnPath,Messageinfo | Export-CSV C:\MessageTrackingLog.csvGet-TransportServer | Get-MessageTrackingLog -ResultSize unlimited -Sender “Sender@emailaddress.com” –Recipient “Recipient@emailaddress.com” -Start "MM/DD/YYYY 00:00:00" -End "MM/DD/YYYY 23:59:00"|Select Timestamp, EventId, Source, SourceContext, MessageID, MessageSubject, Sender,{$_.Recipients}, InternalMessageID, ClientIP, ClientHostName, ServerIp, ServerHostName, ConnectorID,{$_.RecipientStatus},TotalBytes,RecipientCount,RelatedRecipients,Reference, ReturnPath,Messageinfo | Export-CSV C:\MessageTrackingLog.csv
$ErrorActionPreference = "SilentlyContinue"
$WarningPreference = "SilentlyContinue"
$ToAddress = "rajkumar.mcitp@outlook.com"
$FromAddress = "Reporting Email Address"
$Body = "Please find the attached Mailbox Stats report for MRC"
$MailboxUsers = Get-Mailbox -Resultsize Unlimited | sort displayname
$Output=@();
foreach ($user in $MailboxUsers)
{
$Name = $user.Alias
$MBsize = Get-MailboxStatistics $Name
$archive = Get-Mailboxstatistics $name -archive
$Select = New-Object Object;
# Selecting information to the object
$Select | Add-Member NoteProperty "Display Name" $user.name;
$Select | Add-Member NoteProperty Alias $user.alias;
$Select | Add-Member NoteProperty "Primary SMTP Address" $user.PrimarySMTPAddress;
$Select | Add-Member NoteProperty "Recipient Type" $user.recipienttypedetails;
$Select | Add-Member NoteProperty "Use DB Quota Defaults" $user.UseDatabaseQuotaDefaults;
$Select | Add-Member NoteProperty "Prohibit Send At" $user.ProhibitSendQuota:
$Select | Add-Member NoteProperty "Prohibit Send\Receive At" $user.ProhibitSendReceiveQuota;
$Select | Add-Member NoteProperty "Database" $MBsize.Database;
$Select | Add-Member NoteProperty "Server Name" $MBsize.ServerName;
$Select | Add-Member NoteProperty "Server Name" $MBsize.MailboxGuid;
$Select | Add-Member NoteProperty "Mailbox Size" $MBsize.TotalItemSize;
$Select | Add-Member NoteProperty "Item Count" $MBsize.ItemCount;
$Select | Add-Member NoteProperty "Last Accessed Time" $MBsize.LastLogonTime;
$Select | Add-Member NoteProperty "Last Logon Account" $MBsize.LastLoggedOnUserAccount;
$Select | Add-Member NoteProperty "Storage Limit Status" $MBsize.StorageLimitStatus;
$Select | Add-Member NoteProperty "Deleted Item Count" $MBsize.DeletedItemCount;
$Select | Add-Member NoteProperty "Use Database Quota Defaults" $user.WhenMailboxCreated;
# Add the object to our array of output objects
$Output += $Select;
}
$Output | Export-CSV -Path "C:\Mailboxreport.csv" -NoTypeInformation
$attachments = "C:\Mailboxreport.csv"
send-mailmessage -to $ToAddress -from $FromAddress -subject "Mailbox Reports"
-smtpserver exchangeserver.chennai.com -attachments $attachments -body $body
Send-MailMessage -To rajkumar.mcitp@outlook.com -From ExchangeAdmin@DomainName.com -Subject "Subject Name" -SmtpServer servername.domainname.comBelow are the parameters available with Send-MailMessage
Send-MailMessage -To rajkumar.mcitp@outlook.com -From ExchangeAdmin@Chennai.com -Subject "Test Email" -SmtpServer "ExchangeServer@Chennai.com -Body "This is a Test Email" -Attachments "C:\Output.csv" -BodyAsHtml $True -Cc "admin1@chennai.com" -Bcc "Admin2@Chennai.com" -Port 25 -Prority High -UseSsl $falseNote: Send-MailMessage only works when PowerShell Version 2.0 or later