Solved

Query AD for list of users created within 2 month.

Posted on 2010-08-23
4
556 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 57

Accepted Solution

by:
Mike Kline earned 500 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Always backup Domain, SYSVOL etc.using processes according to Microsoft Best Practices. This is meant as a disaster recovery process for small environments that did not implement backup processes and did not run a secondary domain controller that ne…
Had a business requirement to store the mobile number in an environmental variable. This is just a quick article on how this was done.
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

752 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