Diasble an AD Account

Question

Hi All

i have below AD users in a csv file, the file is in below format. i want to import this csv file and disable all these account in AD. experts guide me.

users
user1
user2
user3

will the below syntax work.

$users=Get-Content c:\temp\users.csv
ForEach ($user in $users)
{
Disable-ADAccount -Identity $($user.name)
}

After disabling i want to import the csv file for checking the status i want to export output to csv file, how would i get that information, something like this i want to try

$users=Get-Content c:\temp\users.csv
ForEach ($user in $users)
{
Get-ADUser -Identity name,enabled | export-csv c:\temp\output.csv -NotypeInformation
}

Answer 1

This bit of your code will never work:

$users=Get-Content c:\temp\users.csv
 ForEach ($user in $users)
 {
     Disable-ADAccount -Identity $($user.name)
 }

Each "$user" object in the "$users" array is just a simple string. A string object has no property named "name". The result is that you're trying to use $null as the value for the -Identity parameter value.

What sort of identity have you placed in your file (users.csv)? Acceptable values would be one of these:

A distinguished name
A GUID (objectGUID)
A Security Identifier (objectSid)
A SAM Account Name (SAMAccountName)

With an appropriate identity in the CSV column named "name", this should produce the results you want:

Import-Csv c:\temp\users.csv |
    ForEach-Object {
        Disable-ADAccount -Identity $user.name -PassThru |
            Select-Object SamAccountName,enabled
    } | Export-Csv c:\temp\output.csv -NotypeInformation

Answer 2

Hi @Glenn Maxwell ,

disabling the users should work like you posted in your question.
Best for posting code in Q&A is to use the "Code Sample" icon in the Q&A editor. If you post code in Q&A in normal text format Q&A will screw up the code very often.

To get the user details in a CSV file take a look here: https://www.alitajran.com/export-ad-users-to-csv-powershell/

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Answer 3

i am getting error, is the syntax correct

name
user1
user2
user3

$users=Get-Content c:\temp\users.csv
ForEach ($user in $users)
{
Disable-ADAccount -Identity $($user.name)
}

$users = import-csv c:\temp\users.csv
$results = ForEach ($user in $users){
           Get-ADUser -Identity $user.name| select SamAccountName,enabled
}
$results | export-csv c:\temp\output.csv -NotypeInformation

Answer 4

Hi @Glenn Maxwell ,

first of all it would be helpful to see the error message ;-)

Why are you using Get-Content in the first and import-csv to do the same ... reading the csv file?

Try import-csv in the first line as well. If you run all in one script you can just delete line 7``because you already have $usersfilled inline1`.

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten