How to generate and export a computer user last logged into report

Steps to obtain a user's last logon report using PowerShell:

• Identify the domain from which you want to retrieve the report.
• Identify the LDAP attributes you need to fetch the report.
• Identify the primary DC to retrieve the report.
• Compile the script.
• Execute it in Windows PowerShell.
• The report will be exported in the format specified in the script.
• To obtain the report in a different format, modify the script accordingly.

Sample Windows PowerShell script

$Computers =  Get-ADComputer  -Filter {(enabled -eq "true") -and (OperatingSystem -Like "*XP*")} | Select-Object -ExpandProperty Name
$output=@()
ForEach($PSItem in $Computers) {
    $User = Get-CimInstance Win32_ComputerSystem -ComputerName $PSItem | Select-Object -ExpandProperty UserName
    $Obj = New-Object -TypeName PSObject -Property @{
        "Computer" = $PSItem
        "User" = $User
    }
$output+=$Obj    
}

$output

To obtain the report,

• Login to ADAudit Plus web console as an administrator.
• Navigate to the Reports tab and from the User Logon section in the left pane, select User's last logon report.
• Select the domain and click Generate.
• Select Export As to export the report in any of the preferred formats (CSV, PDF, HTML, CSVDE and XLSX).

Screenshots: