Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Query AD for list of users created within 2 month.

Posted on 2010-08-23
4
Medium Priority
?
569 Views
Last Modified: 2012-05-10
I need to query my AD forest for all user account created within the 2 months.  There are two child domains and a parent domain, if that is relevant.  I want to be able to sort them in excel so UPN, date would be fine.
0
Comment
Question by:every1isevil2
  • 2
  • 2
4 Comments
 
LVL 57

Accepted Solution

by:
Mike Kline earned 2000 total points
ID: 33501751
I helped with a similar question on the technet forums earlier this year

http://social.technet.microsoft.com/Forums/en-US/winserverDS/thread/ca2f8c24-49a4-429a-a686-a99169cc0e00/#74e21dff-106d-4834-b50c-c50dfa9ffa51

Now that one had to do with computers, I'll modify it (adfind method) for you and users

You can get adfind here: http://www.joeware.net/freetools/tools/adfind/index.htm

adfind -default -f "&(objectcategory=person)(objectclass=user)(whencreated>=20100623000000.0Z)" samaccountname givennname sn mail -csv > c:\usersLastyear.csv

I mentioned the blog post in the technet forum but Scott explains whencreated http://blog.scottlowe.org/2006/10/11/finding-recently-created-active-directory-accounts/

Please let me know if that file works ok.

Thanks

Mike
0
 
LVL 4

Author Comment

by:every1isevil2
ID: 33502122
Gonna take a look right now!
0
 
LVL 4

Author Comment

by:every1isevil2
ID: 33502487
Perfect.  Performs exactly what I expected it to do.  Thank you.
0
 
LVL 57

Expert Comment

by:Mike Kline
ID: 33505389
Outstanding...glad I was able to help
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
Microsoft Office 365 is a subscriptions based service which includes services like Exchange Online and Skype for business Online. These services integrate with Microsoft's online version of Active Directory called Azure Active Directory.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question