I have been having a Twitter conversation with Martin Byford-Rew the IT Manager at Thomas Deacon Academy in Peterborough and others about finding stale accounts in active directory, now I do not have that concern as I use an AD tools which runs overnight and creates or archives accounts as pupils, staff and parents arrive at or leave Twynham, but more of that in a later post.
Before we used the current AD tools I also had the same problem with keeping Active Directory tidy and up to date the only way I found before reaching for scripting tools was to use the query tools available in Active Directory so I hope this post helps Martin.
- Open Active Directory users and computers at the top you will see “saved queries”
- Right click Saved Queries and choose new query
- Put a name in the name field I chose “Not Logged On For 30 Days”

- You can choose to query the whole of your directory or just one OU
- Click Define Query
- If you are only interested in finding accounts that have not logged on for a while you get the choice between 30,60,90,120 or 180 days since last logon
We only use these queries now to check out parental accounts for inactivity but a tool that is built in but rarely used. Below you can see the results of the query that we created.
No related posts.







2 comments
3 pings
Namescape – Active Directory Software Solutions
March 8, 2010 at 3:04 am (UTC 1) Link to this comment
Thanks for the useful tips. I found your post very informative and helpful.
Ashley
September 8, 2010 at 5:36 pm (UTC 1) Link to this comment
hey, nice blog…really like it and added to bookmarks. keep up with good work
Sharepoint Active Directory
March 13, 2010 at 7:20 pm (UTC 1) Link to this comment
[...] on active directory users … 8 ways to use sharepoint for social computing | endusersharepoint.com Finding stale accounts in active directory Creating applications using sharepoint Getting active directory ready for sharepoint 2010 A quick [...]
Sharepoint Active Directory
May 21, 2010 at 1:20 am (UTC 1) Link to this comment
[...] Fatayat Twitter Related weblogs Configuring incoming email in sharepoint 2010 | sharepoint george Chris and daves sharepoint and tech blog » finding stale accounts … Microsoft groove server 2010 | free software download & reviews … Announcing the availability [...]
ItsOnTv
March 14, 2011 at 2:05 am (UTC 1) Link to this comment
Thanks, found the article on google, nice post fella…
I saw recently so sending a trackback to my site, thx again Si…