In this post we will be talking about the very basic of using powershell to generates reports. (Please note, there would be updates to this post as and when required)
To get the different types of recipient in your ORG and their Count
Get-Recipient | group -Property RecipientType | Sort Count -Descending | Select name, Count
Name                                                                           Count
——–                                                                            —–
UserMailbox                                                                   10
MailUser                                                                           7
MailContact                                                                      2
DynamicDistributionGroup                                             1
MailUniversalDistributionGroup                                    1
 
 
Distribution of Mailbox Among various Mailbox Servers in your org
Get-Mailbox | group -Property Servername | Sort Count -Descending | Select name, Count
 
 
To get the list of recipients who actually have a mailbox
Get-Recipient | Where{$_.recipientType -eq “UserMailbox”}
 
I know, you might think why should I use this rather I will use Get-Mailbox right ??? Correct, but since this post is regarding Powershell wanted to show how we can use the “Where” clause to achieve the same !
 
 
Get the list of Mailbox that have an archive and that too we are only interested in Local archive not remote
Get-Mailbox | Where{$_.ArchiveStatus -eq “Active” -and $_.ArchiveState -eq “Local”}
 
 
Please do let know what kind of clauses, powershell scripts etc that you want to be discussed, If possible will create a post for the same.
Advertisements