Solved

Can I query for what times a user authenticated against AD using DSQUERY?

Posted on 2008-09-29
4
323 Views
Last Modified: 2013-12-24
Can I query for what times a user authenticated against AD using DSQUERY?  I'm running in mixed mode.
0
Comment
Question by:instaIT
  • 2
4 Comments
 
LVL 3

Expert Comment

by:R_Janssen
ID: 22597023
Yep,
Example:
dsquery * "cn=Bill Gates,ou=test,dc=microdomain,dc=com" -scope base -attr
lastLogonTimestamp
 
0
 
LVL 70

Expert Comment

by:Chris Dent
ID: 22597067

That won't be entirely accurate. The attribute is described here:

http://msdn.microsoft.com/en-us/library/ms676824.aspx

And discussed here:

http://www.microsoft.com/technet/scriptcenter/topics/win2003/lastlogon.mspx

Which tells us that the attribute above may be off by as much as 14 days.

So it's great, depending on how accurate you need / want to be.

Chris
0
 
LVL 1

Author Comment

by:instaIT
ID: 22597078
Is there a way to see the history over a period of time rather than just the last logon stamp?
0
 
LVL 70

Accepted Solution

by:
Chris Dent earned 500 total points
ID: 22597149

Nope, both lastLogon and lastLogonTimeStamp are single value attributes.

Basically, if you want a history you'd have to write something to maintain it, perhaps something through a logon script?

It would be possible to do it on the server side, but for accuracy you'll need the lastLogon attribute. The problem is, that one isn't replicated, which means you have to check every DC in your environment to get the actual value. That would be painful if it were required of a regular basis.

Chris
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now