export users

Question

Hi All

i have samaccount names in the below format in the csv file. some of the users are disabled. i want to import this csv file and pull only enabled samaccount account users . i want the output with samaccountname,displayname,UserPrincipalName. please guide me.

Answer 1

This works for me:

import-csv C:\junk\input.csv |
    ForEach-Object{
        Get-ADUser -Filter "SamAccountName -eq '$($_.sname)' -and enabled -eq 'true'" | 
            Select-Object samaccountname, displayname, UserPrincipalName 
    } | Export-Csv C:\junk\output.csv -NoTypeinformation -Append

Answer 2

Use Import-CSV and pipe the date into a ForEach-Object loop. Use a filter on Get-ADUser. Pipe the output of that into a Select-Object. Pipe the output from the ForEach-Object loop into Export-CSV.

Here's an example of using the filter:

Get-ADUser -Filter "samaccountname -eq '$($_.sname)' -and enabled -eq 'true'"

Answer 3

i am getting error using the below syntax

import-csv C:\temp\input.csv | Get-ADUser -Filter "samaccountname -eq '$($_.sname)' -and enabled -eq 'true'" | Select-Object samaccountname, displayname, UserPrincipalName | Export-Csv C:\temp\output.csv -NoTypeinformation -Append