how to combine 2 ForEach in exchange shell

Question

Hello everyone.

Can you help me combine 2 scripts in one powershell command

export mailbox from csv
in status completed - disable user
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

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.

Accepted Answer

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

all working. thanks !!!

Share via

how to combine 2 ForEach in exchange shell

1 additional answer