Getting CN names from samaccounts from AD using powershell

Question

Hello Experts,

Im looking to export CN names for list of SAMaccount I have in File.

Lets say I have a txt file and it contain all the samaccounts now i want all the CN names for each samaccount in AD.

Can any one give me an idea how to write the script to query across the AD and get this CN names for my list.

Please help me with the cmdlets that can be used.

Regards,
Ram

Answer 1

Hello @Ramanjaneyulu Butharaju

This should be simple:

Import-module activedirectory
Get-ADUser -Filter * -SearchBase "OU=Abc, DC=example, DC=com" | Select sAMAccountName, name | export-csv -Path c:\Scripts\Users.csv

You can use other select properties from: https://social.technet.microsoft.com/wiki/contents/articles/12037.active-directory-get-aduser-default-and-extended-properties.aspx

Like:

Import-module activedirectory
Get-ADUser -Filter 'Company -like "Alpha*"' -Properties * | Select -Property EmailAddress,GivenName,Surname,DisplayName,Title,Department,Office,OfficePhone,MobilePhone,Fax,StreetAddress,City,State,PostalCode,Country | Export-CSV " c:\Scripts\Users.csv" -NoTypeInformation -Encoding UTF8

Hope this resolves your query,
Best regards,

Answer 2

Something like that should work...

Create a file (C:\Temp\List_Users.txt) where you have all sAMAccountName i that file

foreach($line in Get-Content C:\Temp\List_Users.txt) {
Get-ADUser -Identity $line -Properties CN | Select-Object sAMAccountName,CN | Export-Csv -path C:\Temp\Export_AD_User.txt -Append
}

hth