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

Help with a powershell script to retrieve lastlogon from all DCs

I have a script that currently queries all of our DCs, for the lastlogon of a user. I have to query all DCs because this field isn't replicated between DCs.
LastLogonTimestamp is replicated, but it doesn't meet our needs, because is usually different from any of the last logons, sometimes by a week.

The commands I use are;

get-QADUser 'username'  -Service dc01 | Select-Object Name,lastlogon
get-QADUser 'username'  -Service dc02 | Select-Object Name,lastlogon
get-QADUser 'username'  -Service dc03 | Select-Object Name,lastlogon
get-QADUser 'username'  -Service dc04 | Select-Object Name,lastlogon
get-QADUser 'username'  -Service dc05 | Select-Object Name,lastlogon

Is there any better way to query the DCs for the same information? also, It would be great if it only returned the most recent from all.

  • 5
  • 3
1 Solution
Something like this?
foreach $dc in (Get-QADComputer | where { $_.ComputerRole -eq "DomainController"})
 $tempd=(get-QADUser 'username'  -Service $dc | Select-Object Name,lastlogon)
 if ($tempd -gt $lastlogon)

Open in new window

Sorry for a typo. The first line should be: $lastlogon=(get-date).AddYears(-100)
LindySAuthor Commented:
It almost works, but I get the following error for all 5 DCs.

Get-QADUser : Server not exist or could not be contacted: Domain\DC01$
At C:\users\scripts\test.ps1:17 char:21
+  $tempd=(get-QADUser <<<<  'username'  -Service $dc | Select-Object Name,lastlogon)
+ CategoryInfo          : NotSpecified: (:) [Get-QADUser], ServerNotOperationalException
+ FullyQualifiedErrorId : Quest.ActiveRoles.ArsPowerShellSnapIn.DirectoryAccess.ServerNotOperationalException,Quest.ActiveRoles.ArsPowerShellSnapIn.Powershell.Cmdlets.GetUserCmdlet
Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!

LindySAuthor Commented:
Working with what gtworek provided, I have come up with;
$dcs = Get-Content "C:\temp\serverlist.txt"
 foreach($dc in $dcs){ get-QADUser 'username'  -Service $dc | Select-Object Name,lastlogon}

It was taking way too long to query all of the computers looking for domain controllers. By putting them in a text file it sped the query qlot.

Any ideas on how to return only the most recent lastlogon?
Dale HarrisProfessional Services EngineerCommented:
You'd be better of getting the "LastLogonTimestamp" and just using the info from one DC provided you didn't need them any more recent than 9-14 days.  Here's why:

I would verify that they are old/stale users, but for the most part that should fix it.

Here's some code I found from a Quest scripting guy:

# calculate a deadline date. (now minus 60 days)
$deadline = (Get-Date).AddDays(-60).ToFileTimeUtc()

#construct a ldap query
$ldapQuery = '(|(!(lastLogonTimeStamp=*))(lastLogonTimeStamp<=' + $deadline + '))'

#run this query
Get-QADUser -Enabled -SizeLimit 0 -LdapFilter $ldapQuery

#Script from:http://powergui.org/thread.jspa?threadID=8218


Dale Harris
LindySAuthor Commented:
I've requested that this question be deleted for the following reason:

It turns out that the reason I wanted this script is not going to work for me.
Does it crash with error? Or provides wrong results? Or gives you useless information?
Please give us more information why it is not what you expected.
LindySAuthor Commented:
No, It works, but I was trying to get to where I could disable bulk users after I ran this to get the inactive ones.
It turns out that I cannot modify users with a script in our organization, so I've been wasting my time trying to get to a solution.

Thanks for the help anyway.
LindySAuthor Commented:
Thanks for the help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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