I know that the below command will not be as effective but it does the job.
Step-by-Steps
- Go to Active Directory/Domain Controller
- Open Powershell as administrator
- Type the following command below;
Get-ADUser -Properties * -Filter * | Export-csv “ADUserattributes.csv”
OR
Get-ADUser -Filter * -Properties * | Export-csv “ADUserattributes.csv”
The above command will export the list of AD Users with attributes and values in a csv file format, and all you need to do is to copy out the attributes and paste it in a new excel file, format it from column view to row view(optional).
*Note: You could modify the command as you wish