help with Poweshell compare\hashtable

Question

Hello. Looking for help with constructing a PowerShell script that will do the following

1. csv file contains list of users (upn)
2. PowerShell script reads all users from csv file (step1.) does a compare or hash table against users in three specific OU's in AD using (upn). The three specific OU's contain all of our vendor accounts
3. If a match is found, extend account expiration + 90 days
4. if a match is not found write the non matched accounts to a separate .csv file

Thank you very much in advance for any help

Answer 1

Try something like this:

$OUNames = "OU=1,OU=X,DC=domain,DC=tld", "OU=2,OU=Y,DC=domain,DC=tld", "OU=3,OU=X,DC=domain,DC=tld"
Import-Csv C:\Junk\AllHands.csv |
    ForEach-Object{
        $u = Get-ADUser -Filter "userPrincipalName -eq '$($_.UPN)'" -Properties AccountExpires,distinguishedName
        if ($u){
            $OU = $u.DistinguishedName.Substring($u.DistinguishedName.IndexOf('OU=',[System.StringComparison]::CurrentCultureIgnoreCase))
            if ($OUNames -contains $OU){
                Set-ADAccountExpiration -Identity $u.distinguishedName -DateTime ([datetime]::fromfiletime($u.accountexpires)).AddDays(90)
            }
            else{
                $_
            }
        }
        else {
            $_
        }
    } | Export-Csv C:\Junk\WhoAreThesePeople.csv -NoTypeInformation

NOTE: I haven't run this code. You should try it first by adding the "-WhatIf" switch to the Set-ADAccountExpiration cmdlet until you're sure it does what you want!

Answer 2

Thank you very much. I appreciate your help! I will test in our lab