powershell script

spiceuser-dk5ee · 2020-06-18T12:30:40.000Z

test

linkzeta · 2020-06-18T12:52:54.000Z

Hi there,

I fully recommend separate your CSV file with comma or another character, then:

PS C:\> $users = Import-Csv -Delimiter "," -Path .\users.csv
PS C:\> ForEach ($user in $users) { if ($user.employeetype -eq 'External') { Write-Host "Put your command into this brackets for the user ---> " $user.samaccountname }}

This works fine on my desktop.

linkzeta · 2020-06-18T12:56:00.000Z

And, if you want it into one command:

PS C:\> Import-Csv -Delimiter "," -Path .\users.csv | ForEach-Object { if ($_.employeetype -eq 'External') { Write-Host "put your command into this brackets for the user --> " $_.samaccountname }}

spiceuser-dk5ee · 2020-06-18T13:00:42.000Z

great , let me give a try on sample file and will let you know

spiceuser-dk5ee · 2020-06-18T14:00:40.000Z

thanks for the answer i tested script with minor changes and it worked fine

Import-Csv ‘C:\Users\myaccount\Desktop\contractor.csv’ | ForEach-Object { if ($.employeetype -eq ‘External’) { Set-ADUser -Identity $.sAMAccountname -AccountExpirationDate $([datetime]$_.EndDate)}}

One quick question do you know why account is extending 1 day less like in csv if expiration date is 09/30/2020 post script complete expiration date set to 09/29/2020 . any idea how i can add +1 day ?

linkzeta · 2020-06-19T05:36:20.000Z

Hi there,

Nope, that’s strange to mee too o.O…