Windows Server 2000/2003 Thread, list of inactive users in Technical; hey ppl, I'm trying to create a query to get a list of users inactive for 60 days or users ...
-
26th April 2011, 02:14 PM #1 list of inactive users
hey ppl, I'm trying to create a query to get a list of users inactive for 60 days or users who have not logged on to the network for 60 days. I tried to run dsquery but got an "dsquery failed: the parameter is incorrect. Windows could not run this query because you are connected to a domain that does not support this query". Any help on this is appreciated
-
-
IDG Tech News
-
26th April 2011, 03:09 PM #2 What's the functional level of your domain/forest? That might be where dsquery is choking.
dsquery -inactive 8
will give you a list of people who haven't logged in for 8 weeks (56 days)
Use the -o option to format the output (samid for example) and the -limit option to set how many to display.
dsquery user /? for usage.
It's also (iirc) a pre-canned GUI query from AD Users and Computers.
Last edited by pete; 26th April 2011 at 03:12 PM.
-
Thanks to pete from:
nephilim (26th April 2011)
-
26th April 2011, 07:37 PM #3 functional level of your domain = Windows 2000 native
-
-
26th April 2011, 08:00 PM #4 You would want to filter out any resource/service accounts as these wil be inactive but used.
-
-
26th April 2011, 08:20 PM #5 I think you can do an advanced search in AD for people who have not logged in for a set period. I then tend to select all remove to a new ou and then wait a few months and then finally delete the accounts.
-
-
26th April 2011, 09:11 PM #6 
Originally Posted by
techie211
functional level of your domain = Windows 2000 native
That'll be why - dsquery relies on lastLogonTimeStamp, which needs 2003 native or greater.
-
-
27th April 2011, 02:11 PM #7 What is my next option as I can't switch domain function levels yet?
-
-
27th April 2011, 02:14 PM #8 
Originally Posted by
techie211
What is my next option as I can't switch domain function levels yet?
In Ad open up search - select the Find: drop down menu and select Common Queries. You can then select select days since last logon.
-
2 Thanks to glennda:
joe90bass (27th April 2011), timzim (27th April 2011)
-
27th April 2011, 02:20 PM #9 
Originally Posted by
glennda
In Ad open up search - select the Find: drop down menu and select Common Queries. You can then select select days since last logon.
I've run dsquery before to disable inactive accounts, but shockingly I didn't know you could do this! So easy, so obvious...... And I see I can do what I wanted to check out - see who has non-expiring passwords!
-
-
27th April 2011, 02:21 PM #10 
Originally Posted by
joe90bass
I've run dsquery before to disable inactive accounts, but shockingly I didn't know you could do this! So easy, so obvious...... And I see I can do what I wanted to check out - see who has non-expiring passwords!
it took me a lot of googling to find that!
-
-
27th April 2011, 02:57 PM #11 
Originally Posted by
glennda
In Ad open up search - select the Find: drop down menu and select Common Queries. You can then select select days since last logon.
I'm at that section but I get nothing in results..?? what do I put in the 'Name' and 'Description' box? thanks
-
-
27th April 2011, 02:59 PM #12 
Originally Posted by
techie211
I'm at that section but I get nothing in results..?? what do I put in the 'Name' and 'Description' box? thanks
nothing - just make sure you are search whole domain.
-
-
27th April 2011, 03:06 PM #13 when I search for just 'Disabled accounts' I get results but once I select a 'Days since last logon' the results window is blank..?? could it be my domain function level again?
-
-
27th April 2011, 03:10 PM #14 
Originally Posted by
techie211
when I search for just 'Disabled accounts' I get results but once I select a 'Days since last logon' the results window is blank..?? could it be my domain function level again?
not to sure - have you tried the smallest amount of days?
-
-
27th April 2011, 03:15 PM #15
-
SHARE:
Similar Threads
-
By newcareer in forum MIS Systems
Replies: 4
Last Post: 20th August 2010, 08:11 AM
-
By leco in forum MIS Systems
Replies: 3
Last Post: 26th January 2009, 02:46 PM
-
By sLiDeR in forum Windows
Replies: 6
Last Post: 4th December 2007, 01:40 PM
-
By Halfmad in forum Windows
Replies: 10
Last Post: 31st March 2007, 05:40 PM
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules