Can Active Directory export lists and flip users' first names with their last names?

Question

Hi,

So I've got an Excel file with a bunch of people's names. They're all employees of my company. Their names are organized by "last name, first name." I've been tasked with getting lists of all employees' names in active directory. I know how to generate and export .CSV lists, but those lists will have their names exported as "first name, last name", presumably because that's how they appear in active directory. Is there any way to generate those lists with the last names and then the first name? Preferably with a comma in between those names? Thanks for your time.

Answer 1

Hi,

You can give a try to some PowerShell script like this

Get-ADUser -Filter * | Select-Object surname,givenname | Export-Csv -Path C:\temp\names.csv -NoTypeInformation

Best Regards,

Ian Xue

---

If the Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.