how to combine 2 ForEach in exchange shell

Question

Hello everyone.

Can you help me combine 2 scripts in one powershell command

1. export mailbox from csv
2. in status completed - disable user
3. clean username from all distributiongroups

all my scripts is working, but i need in 1 task. Thank you

i think this script need to be out-file with sAMAccountName of users, but i don't know how)

$users = import-csv "C:\csv\СписокУволенныхСотрудников.csv" $Data = @() Import-Module ActiveDirectory Add-PSSnapin Microsoft.Exchange.Management.PowerShell.SnapIn foreach ($user in $users){
$UserName = $user.name +" "+$user.Surname
$temp = Get-ADUser -Filter 'Name -eq $UserName' | select sAMAccountName

and then

1. starts from export mailbox from csv script,

$users = import-csv "C:\csv\СписокУволенныхСотрудников.csv" $Data = @() Import-Module ActiveDirectory Add-PSSnapin Microsoft.Exchange.Management.PowerShell.SnapIn foreach ($user in $users){
New-MailboxExportRequest -Mailbox $temp.sAMAccountName -Name $user -FilePath \exchange\fired$user.pst }

then need disable mailbox and remove completed list

Import-Module ActiveDirectory Add-PSSnapin Microsoft.Exchange.Management.PowerShell.SnapIn
foreach ($user in $users){

Disable-ADAccount -Identity $($sAMAccountName)
Get-ADUser -Identity $sAMAccountName | Move-ADObject -TargetPath "OU=DisabledAcounts,DC=next,DC=local" If ((Get-MailboxExportRequest $fileName).Status -eq "Completed"){
Disable-Mailbox -Identity $sAMAccountName -confirm:$false
Get-MailboxExportRequest -Status Completed | Remove-MailboxExportRequest -Confirm:$false
}
}

and combine in 1 powershell with finish script remove from all distribgroups by list

ForEach ($Group in $DistributionGroups)
    {
        If ((Get-DistributionGroupMember $Group.Name | Select -Expand PrimarySmtpAddress) -contains $($sAMAccountName))
        {
            Remove-DistributionGroupMember -Identity $Group.Name -Member $($sAMAccountName) -Confirm:$false
            Write-host "Removed user from group '$Group'" -f Green
        }
    }  

IF anyone can help me - i'll answer immediately.

Answer 1

Hi Ilya,

I Prepare something for you, the logic works(Also you can verify that without the exchange cmdlets)

Import-Module ActiveDirectory
Add-PSSnapin Microsoft.Exchange.Management.PowerShell.SnapIn
$users = import-csv "C:\csv\СписокУволенныхСотрудников.csv"
function exportMailbox {
    param (
        $sam
    )
    New-MailboxExportRequest -Mailbox $sam `
        -Name $user -FilePath \exchange\fired$sam.pst
}
function getDgroups {
    param (
        $sam
    )
    $groups=`
        $(Get-DistributionGroup -ResultSize Unlimited | Where-Object { $_.Members -like "*,$($sam)" })
    $groupMemberships = $groups | Select-Object Name
    return $groupMemberships
}
function disableuser {
    param (
        $sam
    )
    Write-Host("Disable identity "+$sam)
    Disable-ADAccount -Identity $sam
    Write-Host("Move to OU disable "+$sam)
    Get-ADUser -Identity $sam | Move-ADObject -TargetPath "OU=DisabledAcounts,DC=next,DC=local"
    $fileName = $sam+"PST"
    if ((Get-MailboxExportRequest $fileName).Status -eq "Completed") {
        Write-Host("Disable and remove mailbox"+$sam)
        Disable-Mailbox -Identity $sam -confirm:$false
        Get-MailboxExportRequest -Status Completed | Remove-MailboxExportRequest -Confirm:$false
    }
}

foreach ($user in $users){
    Write-Host("Get SamaccountName "+$user.name)
    $username = Get-ADUser -Filter 'Name -eq $UserName' | Select-Object sAMAccountName
    exportMailbox($username)
    $groups=getDgroups($username)
    foreach ($group in $groups) {
        Remove-DistributionGroupMember -Identity $group -Member $($username) -Confirm:$false
        Write-Host("removing "+$username+" from group: "+$group)
    }
    disableuser($username)
}

Verify and customize with your requirement and let me know any question.

Cheers,

Luis Arias

---

If the information helped address your question, please Accept the answer.

Answer 2

all working. thanks !!!