Solved

Query AD for list of users created within 2 month.

Posted on 2010-08-23
4
553 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article demonstrates probably the easiest way to configure domain-wide tier isolation within Active Directory. If you do not know tier isolation read https://technet.microsoft.com/en-us/windows-server-docs/security/securing-privileged-access/s…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

740 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