• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1645
  • Last Modified:

AD Query for accounts in one OU last modified X days ago

My organization is trying to streamline our Active Directory cleanup.  Our policy is to leave the accounts of terminated employees in the Disabled Users OU for 30 days.  After 30 days, the account is deleted, pending approval of HR.  

What I am looking for is a query that I can import into AD Users and computers that will do the following:

Search just the Disabled Users OU
List any accounts that has a Modified Date of greater that X days from the current date.

I am not looking for third party tools, as once this process is up and running, it will be delegated to our Help Desk.

I also realize that you can sort the Disabled Users List by Modified date and select the accounts to delete manually, but management wants the process to be as automated as possible.

Any assistance would be greatly appreciated.
0
minder49
Asked:
minder49
1 Solution
 
lalocehCommented:
You need to query for the lastlogontimestamp attibute
http://blogs.technet.com/b/askds/archive/2009/04/15/the-lastlogontimestamp-attribute-what-it-was-designed-for-and-how-it-works.aspx


Yo need to make sure the domain functional level is 2003 and then you can use

dsquery user domainroot -inactive 4 <-- # of weeks
0
 
minder49Author Commented:
That will not work.  The users last log on time could conceivably have been 3 months ago, and they were just terminated.  Think of an employee going on maternity leave, or Short term disability and deciding to not return to work.  That puts there time stamp well outside the retention period.  Add to that this line from the article you linked to:

"With default settings in place the lastLogontimeStamp will be 9-14 days behind the current date. "

This is why I want the query to be based off of Modified Date, since that date reflects when the account was placed in the Disabled Users OU, and starts the clock on our retention policy.

Out Domain Functional Level is 2003.

The goal of this query was to help make the process an turn-key as possible.  This will be something that we hand to the Help Desk to run, so it needs to be a simple as possible.

Thank you for your input.
0
 
JavedtariqCommented:
You can actualy do that with in AD .
You can define the query yourself. i have tried to do that for you but the issue is it is using my AD and OU Structure.
I am attaching two screen shots i hope they will help you to define

Once you have created the Query save it with a name and description then you can export that and import to anyother computer.
You can select 30 days or 60 days and select any OU you like. Doc1.docx
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
minder49Author Commented:
I see where you are headed there, but this also will not work since it is also based on last log on time.  I just tried the query in your screen shot, and it came back with numerous users that were only terminated in the past week.  After looking at logs for a few of them, I think this is because they just locked their workstaions at the end of the day, and did not log off.  That will skew the date.

As far as I can see, the Modified Date on the accounts in Disabled Users is the most accurate date to use.

Thank you for your input.
0
 
ZouleousCommented:
How bout this.  Create an advanced query for the disabled users OU that looks like this:


Advanced-query.JPG
disabled-accounts-query.JPG
0
 
ZouleousCommented:
That query would return everything modified after 8PM on January 4 2010. The date/time
is UTC, so you will have to factor in the timezone delta.

Never done this before, but I think that's how it would be done.
0
 
Mike KlineCommented:
So I'm usually a huge fan of adfind for this.  There is also a really great free tool called adinfo

http://www.cjwdev.co.uk/Software/ADReportingTool/Info.html

See my screenshots

Thanks

Mike

ad-info1.png
ad-info2.png
ad-info3.png
ad-info4.png
0
 
minder49Author Commented:
Zouleous:

That is the closet solution to the requirements I have seen.  When I get back to work Monday I will test it out and Bring the Help Desk in to run them through it a few times.

mkline71:

I like the look of adinfo, but we cannot use third party apps.  But thank you for adding another tool to my kit!
0
 
QlemoC++ DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now