PowerShell: Microsoft Exchange Admin Reports

Function importExchangeModule{
$snapinLoaded = (get-pssnapin microsoft.exchange.management.* -ErrorAction SilentlyContinue).Name

$exchangeVersion=(GCM Exsetup.exe | % {$_.FileVersionInfo}).ProductVersion
$exchangeVersionMajor=$exchangeVersion.Substring(0,2);
$exchangeVersionMinor=$exchangeVersion.Substring(3,2);
$exchangeYear=0;
if (!($snapinLoaded)){

switch ([int]$exchangeVersionMajor){
6 {
$exchangeYear=2003;
Add-PSSnapin Microsoft.Exchange.Management.PowerShell.Admin -ErrorAction Continue;
break;
}
8 {
$exchangeYear=2007;
Add-PSSnapin Microsoft.Exchange.Management.PowerShell.Admin -ErrorAction Continue;
break;
}
14 {
$exchangeYear=2010;
Add-PSSnapin Microsoft.Exchange.Management.PowerShell.E2010 -ErrorAction Continue;
break;
}
15 {
$exchangeYear=2013;
Add-PSSnapin Microsoft.Exchange.Management.PowerShell.SnapIn -ErrorAction Continue;
}
15 {
if([int]$exchangeVersionMinor -eq 1){$exchangeYear=2016;}
Add-PSSnapin Microsoft.Exchange.Management.PowerShell.SnapIn -ErrorAction Continue;
}
15 {
if([int]$exchangeVersionMinor -eq 2){$exchangeYear=2019;}
Add-PSSnapin Microsoft.Exchange.Management.PowerShell.SnapIn -ErrorAction Continue;
}
}
"Exchange Server $exchangeYear is detected...`nThe appropriate Exchange PowerShell Snap-In has been imported...";
}
}

# This function is deprecated
function addAdminRoles{
$roles="Mailbox Import Export","Mailbox Search","Discovery Management"
# Exchange Admins need these three roles to perform operations on mailboxes: Organization Management, Mailbox Search, Mailbox Import Export, and Discovery Management
New-ManagementRoleAssignment -Name "Import Export_Organization Management" -SecurityGroup "Organization Management" -Roles $roles
}

#### Export all mailboxes to a network backup location ####
function exportAllMailboxes{
$storageUNC="\\FILESHERVER01\Backups\PSTs"
function monitorCompletion($check){
$migrationStatus=(Get-MailboxExportRequest -Mailbox $check).Status
$completed=$migrationStatus -like 'Completed'
if (!($completed)){
Write-Host -NoNewline "Waiting for $check batch to complete..."
$dots=50
$timeout=10 #10 seconds
while (!($completed)) {
$dots-=1;
#$timeout-=2; # Timeout is optional
#if($timeout -lt 0){"$timeout seconds have passed. Skip this waiting."; continue;}
if ($dots -eq 0){Write-Host ".";$dots=50;} # reload dots
else {Write-Host -NoNewline "."}
Start-Sleep -s 2
$completed.Refresh()
}
}
Write-Host "$check batch is completed."
}

$userAliases=Get-Mailbox -ResultSize unlimited
foreach ($userAlias in $userAliases){
New-MailboxExportRequest -Mailbox $userAlias -FilePath "$storageUNC\$userAlias.pst"
sleep 10;
# monitorCompletion $userAlias;
}
}

#### Create roles resport ####
function rolesReport{
$rolesReportFile="C:\rolesReport.csv"
$roles="Organization Management","Discovery Management"
$report=foreach ($role in $roles){
"$role`:`r-------------------------------------------------";
Get-RoleGroupMember $role | Format-Table;
"`n";
}
$report=$report|Out-String
$report+="`nOther Roles Assignments:`r-------------------------------------------------";
$assignments="Mailbox Import Export","Mailbox Search"
$report+=$assignments | %{Get-ManagementRoleAssignment -Role $_} | Select RoleAssigneename,Role,EffectiveUserName | Out-String
$report | Out-File -FilePath $rolesReportFile
}

#### Create mailbox resport ####
function mailboxesReport{
importExchangeModule;
$reportFile="C:\mailboxesReport.csv"
$sum=0;
$report=@()
$mailboxes=Get-Mailbox -ResultSize Unlimited | sort;
foreach ($mailbox in $mailboxes) {
$mailboxObject = (Get-MailboxStatistics $mailbox.SamAccountName)
$totalItems=$mailboxObject.TotalItemSize.Value.ToMB();
$totalDeleted=$mailboxObject.TotalDeletedItemSize.Value.ToMB();
$thisMailboxSize=$totalItems+$totalDeleted;
$report+=New-Object PsObject -property @{
'DisplayName'=$($mailbox.DisplayName)
'SamAccountName'=$($mailbox.SamAccountName)
'PrimarySmtpAddress'=$($mailbox.PrimarySmtpAddress)
'ServerName'=$($mailbox.ServerName)
'LastLogonTime'=$($mailboxObject.LastLogonTime)
'Database'=$($mailbox.Database)
'IsMailboxEnabled'=$($mailbox.IsMailboxEnabled)
'thisMailboxSize'=[int]$thisMailboxSize;
}
$sum+=$thisMailboxSize;
}
#$sumGB=$sum/1024;
$report+=New-Object PsObject -property @{
'DisplayName'="Total Storage For All Mailboxes"
'SamAccountName'=''
'PrimarySmtpAddress'=''
'ServerName'=''
'LastLogonTime'=''
'Database'=''
'IsMailboxEnabled'=''
'thisMailboxSize'=[int]$sum;
}
$report | Export-Csv -Path $reportFile -NoTypeInformation
"Reviewing exported contents...`n"
Import-Csv -Path $reportFile
}

Leave a Reply

Your email address will not be published. Required fields are marked *