Active Directory 2008

How can a query AD to output data on last account login access?  

Jack_son_Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

KenMcFCommented:
Do you need the last logon time for a user account?

If you do you can use the lastlogontimestamp attribute or the lastlogon attribute. The lastlogontimestamp is replicated to each DC and is updated every 9-14 days. The lastlogon is not replicated so you would need to query every DC. I like to use either ADFind from joeware.net or powershell with the quest AD cmdlets


adfind -default samaccountname=USERNAME lastlogontimestamp -tdcs

get-qaduser USERNAME | ft lastlogontimestamp        
Jack_son_Author Commented:
Yes, but would like to get this for all the users, can you query all users with power shell?

How does ADFind work?
KenMcFCommented:
Yeah, this will export to csv file with the users samaccountname and lastlogontimestamp

adfind -default -f "&(objectcategory=person)(objectclass=user)" samaccountname, lastlogontimestamp -tdcs -csv -nolable -nodn > c:\users.csv


get-qaduser -sizelimit 0 | select samaccountname, lastlogontimestamp | export-csv c:\users.csv
AwinishCommented:
Below is the simple power shell script from technet Gallery, save it as login.ps1 to c drive, open powershell run on powershell(locate the script in powershell windows)  .\login.ps1 >> c:\lastlogin.ps1 from powershell & it will show you the report of last login time.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Active Directory

From novice to tech pro — start learning today.