Report on Addition, Modification, Termination of Exchange users

Recently I came across a new requirement from application team that may be unique to our enviornment but still sharing the code for everyone else to us.

Requirement is below:

  • Report All employees except from vendor
  • Report any new addition from previous report
  • Report on PriomarySMTP modification as compare to previous report
  • Report on any removal of emplooyees mailbox
  • Report should check both Onpremise and Online world

Download and extract the script from below link that fulfills all the above criteria.

https://gallery.technet.microsoft.com/scriptcenter/Report-on-Addition-ed0a8909

 

Logs: Transcript logs

psfile: Previous file

Report: All 4 reports based on time stamp

EmpFeedReport.ps1: Actual powershell Code

State-Email.csv: State file created when you run it first time.

Update the Variables inside the .ps1 script:

########################################################

$limit = (Get-Date).AddDays(-60) #for report/logs rectention – Chnage the limit as per your requirement

$path1 = (Get-Location).Path + “\Logs”

$path2 = (Get-Location).Path + “\Report”

$path3 = (Get-Location).Path + “\Psfile”

$email1 = “VSukhija@labtest.com”

$email2 = “SSukhija@labtest.com”

$from = “DONotReply@labtest.com”

$smtpserver = “SMTP Server”

$collmbx = @()

$collection = @()

$collection1 = @()

$Statefile = “.\State-Email.csv”

$regex = ‘^\d+$’  #This is for matching integer i.e employee id

#########################################################

First we are fetching all mailboxes from onpremise and online enviornment where curtomattribute11 matches intreger and customattribute10 is not like vendor.

$collmbx = get-mailbox -resultsize unlimited -RecipientTypeDetails “UserMailbox” | where{ ($_.CustomAttribute11 -match $regex) -and ($_.CustomAttribute10 -notlike “Vendor”) } | select Name, Customattribute11, PrimarySMTPAddress

$collmbx += get-remotemailbox -resultsize unlimited | where{ ($_.CustomAttribute11 -match $regex) -and ($_.CustomAttribute10 -notlike “Vendor”) } | select Name, Customattribute11, PrimarySMTPAddressWrite-Host “—————————–” -ForegroundColor Green

Now , we will compare the fetched data with the old data that is in state file to find out changes , Additions and removals from last feed.

refer the separate sections inside the script that shows use of compare-object and other comparison operations.

Note: On first run only state file will be created & on next run only other reprts based on changes will get created.

Sharing the code, please modify as per your requirement to reuse it.

<#     
    .NOTES 
    =========================================================================== 
     Created on:       12/8/2016 4:19 PM 
     Updated on:    01/08/2018 
     Created by:       Vikas Sukhija 
     Organization:      
     Filename:         EmpfeedReport.ps1 
    =========================================================================== 
    .DESCRIPTION 
        This Script will send Report of Users to be added to BrainStorm 
        Master/Incremental List of users 
#> 
################Add Modules Exchange############################# 
$error.clear() 
If ((Get-PSSnapin | where { $_.Name -match "Microsoft.Exchange.Management.PowerShell.E2010" }) -eq $null) 
{ 
    Add-PSSnapin Microsoft.Exchange.Management.PowerShell.E2010 
} 
###############ADD Logs & Variables################################ 
$date1 = get-date -format d 
$date1 = $date1.ToString().Replace("/""-"$time = get-date -format t 
 
$time = $time.ToString().Replace(":""-"$time = $time.ToString().Replace(" """) 
 
$log = (Get-Location).Path + "\Logs" + "\" + "Processed_PS_Logs" + $date1 + "_" + $time + "_.log" 
$report1 = (Get-Location).Path + "\Report" + "\" + "Report_Modified" + $date1 + "_" + $time + "_.csv" 
$report2 = (Get-Location).Path + "\Report" + "\" + "Report_ADDS" + $date1 + "_" + $time + "_.csv" 
$report3 = (Get-Location).Path + "\Report" + "\" + "Report_Delete" + $date1 + "_" + $time + "_.csv" 
$report4 = (Get-Location).Path + "\Report" + "\" + "Report_Master" + $date1 + "_" + $time + "_.csv" 
$psfile = (Get-Location).Path + "\Psfile" + "\" + "Psfile" + $date1 + "_" + $time + "_.csv" 
 
$limit = (Get-Date).AddDays(-60) #for report recycling 
$path1 = (Get-Location).Path + "\Logs" 
$path2 = (Get-Location).Path + "\Report" 
$path3 = (Get-Location).Path + "\Psfile" 
 
$email1 = "VSukhija@labtest.com" 
$email2 = "SSukhija@labtest.com" 
$from = "DONotReply@labtest.com" 
$smtpserver = "SMTP Server" 
$collmbx = @() 
$collection = @() 
$collection1 = @() 
$Statefile = ".\State-Email.csv" 
$regex = '^\d+$' 
################Email Function##################### 
 
function Send-Email 
{ 
    [CmdletBinding()] 
    param 
    ( 
        $From, 
        [array]$To, 
        [array]$bcc, 
        [array]$cc, 
        $body, 
        $subject, 
        $attachment, 
        $smtpserver 
    ) 
    $message = new-object System.Net.Mail.MailMessage 
    $message.From = $from 
    if ($To -ne $null) 
    { 
        $To | ForEach-Object{ 
            $to1 = $_ 
            $to1 
            $message.To.Add($to1) 
        } 
    } 
    if ($cc -ne $null) 
    { 
        $cc | ForEach-Object{ 
            $cc1 = $_ 
            $cc1 
            $message.CC.Add($cc1) 
        } 
    } 
    if ($bcc -ne $null) 
    { 
        $bcc | ForEach-Object{ 
            $bcc1 = $_ 
            $bcc1 
            $message.bcc.Add($bcc1) 
        } 
    } 
    $message.IsBodyHtml = $True 
    if ($subject -ne $null) 
    { 
        $message.Subject = $Subject 
    } 
    if ($attachment -ne $null) 
    { 
        $attach = new-object Net.Mail.Attachment($attachment) 
        $message.Attachments.Add($attach) 
    } 
    if ($body -ne $null) 
    { 
        $message.body = $body 
    } 
    $smtp = new-object Net.Mail.SmtpClient($smtpserver) 
    $smtp.Send($message) 
} 
################################################################ 
if ($error) 
{ 
    Write-Host "Error in initialization"; 
    Send-Email -To $email2 -From $from -subject "BrainStrom Report Script initialization failure" -smtpserver $smtpserver 
    timeout 10; exit 
} 
 
Start-Transcript -path $log 
get-date 
################ Collect All mailboxes########################### 
Write-Host "Fetching mailbox data Started" -ForegroundColor Green 
Write-Host "-----------------------------" -ForegroundColor Green 
$collmbx = get-mailbox -resultsize unlimited -RecipientTypeDetails "UserMailbox" | where{ ($_.CustomAttribute11 -match $regex-and ($_.CustomAttribute10 -notlike "Vendor") } | select Name, Customattribute11, PrimarySMTPAddress 
$collmbx += get-remotemailbox -resultsize unlimited | where{ ($_.CustomAttribute11 -match $regex-and ($_.CustomAttribute10 -notlike "Vendor") } | select Name, Customattribute11, PrimarySMTPAddress 
Write-Host "-----------------------------" -ForegroundColor Green 
Write-Host "Fetching mailbox data Finished" -ForegroundColor Green 
if ($error) 
{ 
    Write-Host "Error in Fetching mailboxes data from Exchnage"; 
    Send-Email -To $email2 -From $from -subject "BrainStrom Report error fetching mailboxes" -smtpserver $smtpserver 
    Stop-Transcript; timeout 10; exit 
} 
If (!(Test-Path $Statefile)) 
{ 
    $collmbx | select Name, Customattribute11, PrimarySMTPAddress | Export-csv $Statefile -NoTypeInformation 
} 
 
#########################Start comparison########################## 
 
$stcsv = import-csv $Statefile 
$coll = @() 
 
$Changes = Compare-Object $stcsv $collmbx -property Customattribute11, PrimarySMTPAddress | 
Select-Object customattribute11, PrimarySMTPAddress, @{ 
    n  = 'State'; e = { 
        If ($_.SideIndicator -eq "=>") { "Current" } 
        elseif ($_.SideIndicator -eq "<=") { "Previous" } 
        else { "Ignore" } 
    } 
} 
############################Modifictations############################ 
if ($changes) 
{ 
    $Changes | foreach-object{ 
        $mcoll = "" | select Name, customattribute11, PreviousSMTP, NewSMTP 
        if ($_.state -eq "Previous") 
        { 
            $cus1 = $_.customattribute11 
            $Name = ($collmbx | where{ $_.customattribute11 -eq $cus1 }).name 
            $PreviousSMTP = $_.PrimarySMTPAddress 
            foreach ($chg in $Changes) 
            { 
                if (($cus1 -eq $chg.customattribute11) -and ($chg.state -eq "Current")) 
                { 
                    $NewSMTP = $chg.PrimarySMTPAddress 
                    $mcoll.Name = $Name 
                    $mcoll.customattribute11 = $cus1 
                    $mcoll.PreviousSMTP = $PreviousSMTP 
                    $mcoll.NewSMTP = $NewSMTP 
                } 
            } 
             
        } 
        $collection +$mcoll 
    } 
    $collection1 = $collection | where{ $_.name -ne $null } 
    if ($collection1) 
    { 
        #$collection1 
        $tcoll = $null 
        $tcollection = @() 
        $collection1 | ForEach-Object{ 
            $tcoll = "" | select Department, Name, OldEmail, NewEmail, FirstName, LastName, Title, SystemGroup, UserGroup 
            $user = $null 
            $user = get-user $_.Name 
            $tcoll.Department = $user.department 
            $tcoll.Name = $_.Name 
            $tcoll.OldEmail = $_.PreviousSMTP 
            $tcoll.NewEmail = $_.NewSMTP 
            $tcoll.FirstName = $user.FirstName 
            $tcoll.LastName = $user.LastName 
            $tcoll.Title = $user.Title 
            $tcoll.SystemGroup = "All LAB" 
            $tcoll.UserGroup = "" 
            $tcollection +$tcoll 
        } 
        $tcollection | Export-Csv $report1 -NoTypeInformation 
    } 
     
} 
###########################Additions######################################## 
$mcoll = $null 
$difference = $null 
$collection = @() 
$collection1 = @() 
if ($changes) 
{ 
    $current = $Changes | where{ $_.state -eq "Current" } | select -expand customattribute11 
    $previous = $stcsv | select -expand customattribute11 
    $difference = @() 
     
    $current | ForEach-Object{ 
        if ($previous -notcontains $_) 
        { 
            $difference +$_ 
        } 
    } 
    $difference | ForEach-Object{ 
        $cus1 = $_ 
        $mcoll = "" | select Name, customattribute11, SMTP 
        $diffmbx = ($collmbx | where{ $_.customattribute11 -eq $cus1 }) 
        $mcoll.Name = $diffmbx.Name 
        $mcoll.customattribute11 = $diffmbx.customattribute11 
        $mcoll.SMTP = $diffmbx.PrimarySMTPAddress 
        $collection +$mcoll 
    } 
    $collection1 = $collection | where{ $_.name -ne $null } 
    if ($collection1) 
    { 
        #$collection1 
        $tcoll = $null 
        $tcollection = @() 
        $collection1 | ForEach-Object{ 
            $tcoll = "" | select Department, Name, Email, FirstName, LastName, Title, SystemGroup, UserGroup 
            $user = $null 
            $user = get-user $_.Name 
            $tcoll.Department = $user.department 
            $tcoll.Name = $_.Name 
            $tcoll.Email = $_.SMTP 
            $tcoll.FirstName = $user.FirstName 
            $tcoll.LastName = $user.LastName 
            $tcoll.Title = $user.Title 
            $tcoll.SystemGroup = "All LAB" 
            $tcoll.UserGroup = "" 
            $tcollection +$tcoll 
        } 
        $tcollection | Export-Csv $report2 -NoTypeInformation 
    } 
} 
##################################Removal#################################### 
$mcoll = $null 
$collection = @() 
$collection1 = @() 
if ($changes) 
{ 
    $current = $collmbx | select -expand customattribute11 
    $previous = $stcsv | select -expand customattribute11 
    $difference = Compare-Object $collmbx $stcsv 
     
    $previous | ForEach-Object{ 
        if ($current -notcontains $_) 
        { 
            $difference +$_ 
        } 
    } 
    $difference | ForEach-Object{ 
        $cus1 = $_ 
        $mcoll = "" | select Name, customattribute11, SMTP 
        $diffmbx = ($stcsv | where{ $_.customattribute11 -eq $cus1 }) 
        $mcoll.Name = $diffmbx.Name 
        $mcoll.customattribute11 = $diffmbx.customattribute11 
        $mcoll.SMTP = $diffmbx.PrimarySMTPAddress 
        $collection +$mcoll 
    } 
    $collection1 = $collection | where{ $_.name -ne $null } 
    if ($collection1) 
    { 
        #$collection1 
        $tcoll = $null 
        $tcollection = @() 
        $collection1 | ForEach-Object{ 
            $tcoll = "" | select Department, Name, Email, FirstName, LastName, Title, SystemGroup, UserGroup 
            $user = $null 
            $user = get-user $_.Name 
            $tcoll.Department = $user.department 
            $tcoll.Name = $_.Name 
            $tcoll.Email = $_.SMTP 
            $tcoll.FirstName = $user.FirstName 
            $tcoll.LastName = $user.LastName 
            $tcoll.Title = $user.Title 
            $tcoll.SystemGroup = "All LAB" 
            $tcoll.UserGroup = "" 
            $tcollection +$tcoll 
        } 
        $tcollection | Export-Csv $report3 -NoTypeInformation 
    } 
} 
############################################################################# 
Copy-Item $Statefile $psfile 
timeout 5 
$collmbx | Export-Csv $Statefile -NoTypeInformation # new state 
 
##########################Full Feed######################################## 
$mcoll = $null 
$collection = @() 
$collection1 = @() 
if ($collmbx) 
{ 
    #$collection1 
    $tcoll = $null 
    $tcollection = @() 
    $collmbx | ForEach-Object{ 
        $tcoll = "" | select Department, Name, Email, FirstName, LastName, Title, SystemGroup, UserGroup 
        $user = $null 
        $user = get-user $_.Name | select Department, FirstName, LastName, Title 
        $tcoll.Department = $user.department 
        $tcoll.Name = $_.Name 
        $tcoll.Email = $_.PrimarySmtpAddress 
        $tcoll.FirstName = $user.FirstName 
        $tcoll.LastName = $user.LastName 
        $tcoll.Title = $user.Title 
        $tcoll.SystemGroup = "All LAB" 
        $tcoll.UserGroup = "" 
        $tcollection +$tcoll 
    } 
} 
$tcollection | Export-Csv $report4 -NoTypeInformation 
 
if ($error) 
{ 
    Send-Email -To $email2 -From $from -subject "Email Address Change error Report" -body $Error -smtpserver $smtpserver 
} 
 
if (Test-Path $report1) { Send-Email -To $email1 -bcc $email2 -From $from -subject "BrainStorm Feed Modfified Report" -attachment $report1 -smtpserver $smtpserver } 
if (Test-Path $report2) { Send-Email -To $email1 -bcc $email2 -From $from -subject "BrainStorm Feed ADD Report" -attachment $report1 -smtpserver $smtpserver } 
if (Test-Path $report3) { Send-Email -To $email1 -bcc $email2 -From $from -subject "BrainStorm Feed Delete Report" -attachment $report1 -smtpserver $smtpserver } 
if (Test-Path $report4) { Send-Email -To $email1 -bcc $email2 -From $from -subject "BrainStorm Feed Master Report" -attachment $report1 -smtpserver $smtpserver } 
#######################Recycle####################### 
 
Get-ChildItem -Path $path1 | Where-Object { 
    $_.CreationTime -lt $limit 
} | Remove-Item -recurse -Force 
 
Get-ChildItem -Path $path2 | Where-Object { 
    $_.CreationTime -lt $limit 
} | Remove-Item -recurse -Force 
 
Get-ChildItem -Path $path3 | Where-Object { 
    $_.CreationTime -lt $limit 
} | Remove-Item -recurse -Force 
 
get-date 
Stop-Transcript

Thanks for Reading

Vikas Sukhija

http://SysCloudPro.com

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s