Ever wondered how to fetch the last logon details for a domain member computer or user? Using .Net Microsoft has made it pretty easier for the developers to populate the active directory attributes to desired data repositories, however getting the last logon date time value still remains a complex stuff (for beginners like us), especially when your domain consist of multiple domain controllers and they are spread across different geographical areas and subnets :)
After dwelling for long a while, I came across a C# code snippet @ http://www.codeproject.com/Articles/19181/Find-LastLogon-Across-All-Windows-Domain-Controlle that was mostly built against http://www.rlmueller.net/Last%20Logon.htm
I had to copy the codes those were split into multiple blocks for proper explanations, re-arrange and then using the online C# to VB.Net converters, convert to readable VB.Net coding. Again, there were few mismatches and I was able to figure them out through stackoverflow & tech forums posts.
Without going on with what and how I did it, here comes the complete coding. Please note, this is a console application solution, and you should add the references as seen with the below image in order to successfully call the methods and types
Imports System.DirectoryServices Imports ActiveDs Module Module1 ''' <summary> ''' You should able to easily convert this console application to windows form application ''' with least efforts ''' Original code was posted with http://www.codeproject.com/Articles/19181/Find-LastLogon-Across-All-Windows-Domain-Controlle ''' using C#, I converted most of the C# Codes using online converter(s) ''' and ammended at few places, as the code block provided with the project were not fetching decent results ''' Rajesh Thampi / 15-Jan-2015 | w7bugs at gmail dot com | windows7bugs.wordpress.com ''' </summary> ''' <remarks></remarks> Sub Main() 'Get the root of the directory data tree on a directory server. Dim rootDse As New DirectoryEntry("LDAP://rootDSE") 'Dictionary object to hold the records retrived by the search Dim lastLogons As Dictionary(Of String, Int64) = New Dictionary(Of String, Int64) 'Local variable for holding formatted last logon values in datetime format Dim llogon As DateTime = Nothing 'for User last logon 'Dim TargetUsername As String = "george" ' -> Pass sAMAccountName 'Dim objType As Integer = 805306368 '-> 805306368 User | 805306369 Computer 'for Computer Dim TargetUsername As String = "JOSE-KSP$" ' -> Pass sAMAccountName Dim objType As Integer = 805306369 '-> 805306368 User | 805306369 Computer 'Loop through all available domain controllers For Each dsDC As DirectoryServices.ActiveDirectory.DomainController In _ DirectoryServices.ActiveDirectory.Domain.GetCurrentDomain.DomainControllers 'Print the individual domain controller name 'Debug.Write(dsDC.Name & vbCrLf) ' Uncomment for print 'Get the Entry details for domain controller Dim dirEntry As DirectoryEntry = New DirectoryEntry("LDAP://" + dsDC.Name + "/" + DirectCast(rootDse.Properties("defaultNamingContext").Value, String)) 'Define searcher for the objects of interest Dim dirObjects As DirectorySearcher = New DirectorySearcher(dirEntry) 'Define a large integer to hold the COM object translated value 'ActiveDS COM object is a MUST reference, yet to find another way to deal with highpart, lowpart values obtained from "lastlogon" Dim lastLogonThisServer As Int64 = New Int64() 'Set up the filter for object to be returned through findall method dirObjects.Filter = "(&(sAMAccountType=" & objType & ")(sAMAccountName=" & TargetUsername & "))" ' Loop through the records found For Each objRecords In dirObjects.FindAll() 'Get the directory entry, this will return all the attributes associated with the object (Computer/User) Dim dirObj As DirectoryEntry = objRecords.GetDirectoryEntry() If Not dirObj Is Nothing Then ' Get the distinguishedName and lastLogon for each user Dim distinguishedName As String = dirObj.Properties("distinguishedName").Value.ToString() Try If Not dirObj.Properties("lastLogon").Value Is Nothing Then Dim lgIntas As ActiveDs.LargeInteger = dirObj.Properties("lastLogon").Value Dim lngHigh As Long = lgIntas.HighPart Dim lngLow As Long = lgIntas.LowPart lastLogonThisServer = (lngHigh * (2 ^ 32) - lngLow) End If Catch ex As Exception Debug.Write(ex.Message) End Try 'Different date time formats you can play around with 'Dim format As String = "MMM ddd d HH:mm yyyy" -> Jan Thu 15 08:11 2015 'Dim format As String = "dd/MMM/yyyy HH:mm tt" -> 15/Jan/2015 08:36 AM 'Debug.Write(distinguishedName & ";" _ '& DateTime.FromFileTime(lastLogonThisServer).ToString(format, Globalization.CultureInfo.InvariantCulture) & vbCrLf) 'Save the most recent logon for each user in a Dictionary object 'How it works 'lastLogons dictionary object has two parts, key and corresponding value 'Prior adding a new record, using ContainsKey call we can check the array for existing keys 'With this example, the key is "distinguishedName" 'If the distinguishedName as key found If lastLogons.ContainsKey(distinguishedName) Then 'We compare the latest fetched logon date integer value against the key value of the dictionary object If lastLogons(distinguishedName) < lastLogonThisServer Then 'If the existing value is smaller than the new value "lastLogonThisServer" holds lastLogons(distinguishedName) = lastLogonThisServer 'We will update the existing key value with recent lastLogonThisServer value End If Else 'We will add a new entry to the dictionary object lastLogons.Add(distinguishedName, lastLogonThisServer) End If End If Next Next 'Now we will loop through the dictionary object and fetch the details 'For a single user/computer the dictionary object will not have more than one entry For Each kvp As KeyValuePair(Of String, Int64) In lastLogons Dim v1 As String = kvp.Key Dim v2 As DateTime = DateTime.FromFileTime(kvp.Value).ToString() ' llogon = v2 Dim format As String = "dd/MMM/yyyy HH:mm tt" Debug.Write("Distinguished Name :" & v1 & "; Last logged :" & v2.ToString(format) & vbCrLf) Next End Sub End Module
You may download the solution from https://drive.google.com/file/d/0B-3iVeOMTCbWWFliTGN1NmNxMjQ/view?usp=sharing