Active Directory Query Question - Query Only Enabled Users

I am looking to find a way to be able to to either DSGET, DSQUERY a list of all of the enabled users in a particular OU. More specifically, if you are looking at my screenshot, I need a query of all of the enabled users in the 1575 OU and the disabled users to be excluded.
2016-08-29-09_32_48-NEWSECGXDC---Rem.png
Jonathan DiVincenzoSystem AdministratorAsked:
Who is Participating?
 
FOXActive Directory/Exchange EngineerCommented:
Use powershell, right-click run as administrator
1st command     Import-Module ActiveDirectory
2nd command    Get-ADuser -filter "Enabled -eq 'True'" -searchbase "Ou=ouname,ou=ouname,dc=domain,dc-com" | ft samaccountname, DisplayName | out-file c:\temp\Enabledusers.csv


**To get the path to the OU in question Make sure your view in ActiveDirectory users and computers  has Advance Features checked and User, contacts, groups and computers as containters checked.
Right-click the OU in question, click properties, click the attribute tab, sroll down to distinguishedName, highlight it and click view then do a ctrl c for your copy and then paste after -searchbase in the command above. Make sure the OU path is in quotes " "
0
 
Jonathan DiVincenzoSystem AdministratorAuthor Commented:
Thanks Foxluv,

The commands provided did populate an entire list of all the Enabled users in our domain, but what I need for my client is a concentrated automated list of just the enabled users in 1575 Users OU.
0
 
FOXActive Directory/Exchange EngineerCommented:
Did you read the bottom part of my instructions?  Get the OU from the distinguished name and put it in the -searchbase part of the command
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
Jonathan DiVincenzoSystem AdministratorAuthor Commented:
Ok wow, that was honestly not there when I was looking at that a little bit ago. But since I just reloaded the page, the bottom part appeared. I'll give it a try and see what happens. Thanks!
0
 
Jonathan DiVincenzoSystem AdministratorAuthor Commented:
Awesome, that looks great! Just one little problem. Even though the Display Name perimeter is filled out in AD, the final csv output does not display the Display Name. Any idea what that's all about? See screenshot if needed.
2016-08-29-11_44_29-Microsoft-Excel-.png
0
 
FOXActive Directory/Exchange EngineerCommented:
Try this one, make sure you add in your OU again.

Get-ADuser -filter "Enabled -eq 'True'" -searchbase "Ou=ouname,ou=ouname,dc=domain,dc-com" | ft samaccountname,GivenName,Surname,DisplayName | out-file c:\temp\Enabledusers.csv
0
 
Jonathan DiVincenzoSystem AdministratorAuthor Commented:
Foxluv, you definitely get to take the cake in this one! Thanks a lot!
0
 
FOXActive Directory/Exchange EngineerCommented:
Good work
0
 
Jonathan DiVincenzoSystem AdministratorAuthor Commented:
For whatever reason, Display Name was not working so I removed that value from my command. Otherwise, perfect solution!
0
 
FOXActive Directory/Exchange EngineerCommented:
Jon,
Sorry about the displayname.  If you need it try this.  (put in your OU again)

Get-ADuser -properties * -filter "Enabled -eq 'True'" -searchbase "Ou=ouname,ou=ouname,dc=domain,dc-com" | ft samaccountname,GivenName,Surname,DisplayName | out-file c:\temp\Enabledusers.csv
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.