Forum Discussion

Skipster311-1's avatar
Skipster311-1
Iron Contributor
Nov 05, 2021

Help with script

Hello all This is what i am trying to accomplish.  1. csv file contains a list of users UPN (header in csv = upn) 2. script reads all users from csv import file (step1.) does a compare or hash tab...
Windows PowerShell
Skipster311-1's avatar
Skipster311-1
Iron Contributor
Nov 05, 2021

Skipster311-1 

I have the expiration issue resolved. This actually works for our needs 

"Set-ADAccountExpiration -Identity $u.distinguishedName -TimeSpan 90.0:0"

However im still struggling to get the differences written to the output file

 $OUNames = "OU=FMI,OU=Cognizant,OU=FM Users,OU=Corp,DC=ip-tech,DC=com", "OU=BPO and RPA,OU=Cognizant,OU=Consultants,OU=Users,OU=Corp,DC=ip-tech,DC=com"
 Import-Csv C:\temp\test2.csv |
     ForEach-Object{
          $u = get-aduser -Filter "userPrincipalName -eq '$($_.upn)'"
             if ($u){
             $OU = $u.DistinguishedName.Substring($u.DistinguishedName.IndexOf('OU=',[System.StringComparison]::CurrentCultureIgnoreCase))
             if ($OUNames -contains $OU){
                 Set-ADAccountExpiration -Identity $u.distinguishedName -TimeSpan 90.0:0
             }
             else{
                 $_
             }
         }
         else {
             $_
         }
     } | Export-Csv C:\temp\WhoAreThesePeople.csv -NoTypeInformation

 

Resources