How to get last logon of user using powershell

Active Directory
management Manage, track, and secure Active Directory

Identity governance
and administrationOrchestrate user identity management and access controls for Zero Trust

Privileged access
managementControl and secure privileged access to critical enterprise systems

ADManager Plus
Active Directory, Microsoft 365, and Exchange management and reporting
ADAudit Plus
Hybrid AD, cloud, and file auditing; security; and compliance
ADSelfService Plus
Identity security with adaptive MFA, SSPR, and SSO
Exchange Reporter Plus
Reporting, auditing, and monitoring for hybrid Exchange and Skype
RecoveryManager Plus
Active Directory, Microsoft 365, and Exchange backup and recovery

How to generate and export last logged on user report

System administrators make use of computers' last logon by users report to check for unauthorized logons into the organization's Active Directory. This report can help prevent potential cyberattacks.

The following is a comparison between obtaining an AD computer's last logon by a user report with Windows PowerShell and ADAudit Plus:

Windows PowerShell

Steps to obtain the last logged on users using PowerShell:

Identify the domain from which you want to retrieve the report.
Identify the LDAP attributes you need to fetch for the report.
Identify the primary DC to retrieve the report.
Compile the script.
Execute it in Windows PowerShell.

Sample Windows PowerShell Script

Get-ADComputer -Properties "LastLogonDate"

ADAudit Plus

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 Last Logon on Workstations 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).

Screenshot:

Following are the limitations to obtain a report of last logon on workstations using native tools like Windows PowerShell:

The script can be executed only from the computers which has Active Directory Domain Services role.
It's difficult to generate the report for different time zones and date formats.
It is difficult to export the report in file formats other than CSV.
Applying more filters like OU or 'User name starts with' will increase the LDAP query complexity.

ADAudit Plus will generate the report of last logon of users in a particular workstation and display it in a simple and intuitively designed UI.

Active Directory auditing

Windows file auditing

NAS device file auditing

Windows server auditing

Workstation auditing

Entra ID auditing

All features →

Help documents

Video zone

Webinars

Product brochures

Case studies

E-books

Awards zone

Study

How tos

Best practices

How to generate and export last logged on user report

Windows PowerShell

Steps to obtain the last logged on users using PowerShell:

Sample Windows PowerShell Script

ADAudit Plus

To obtain the report,

Related Resources

ADAudit Plus Trusted By

Meet all auditing and IT security needs with ADAudit Plus.

A single pane of glass for complete Active Directory Auditing and Reporting

Identity and access management

Unified service management

Unified endpoint management and security

IT operations management and observability

Security information and event management

Advanced IT analytics

Low-code app development

Cloud solutions for enterprise IT

IT management for MSPs

Active Directory management Manage, track, and secure Active Directory

Identity governance and administrationOrchestrate user identity management and access controls for Zero Trust

Privileged access managementControl and secure privileged access to critical enterprise systems

Enterprise and IT service managementDeliver a consistent employee experience across business functions

Customer service managementBuild a one-stop portal for customers with efficient account management

IT asset managementCentralize and automate the complete IT asset life cycle

SIEM Spot, investigate, and neutralize security threats

Log and compliance managementGain deeper visibility into security events and ensure compliance

Security auditingAudit Active Directory, cloud platforms and files to enhance your security posture

Endpoint management and protection platform (UEM and EPP)Secure and manage endpoints to protect your IT assets effectively

Endpoint managementAchieve intelligent IT device management with zero user intervention

Endpoint securityDefend against threat actors with proactive and reactive measures

Full-stack observability and digital experience monitoringAchieve end-to-end visibility, proactive issue resolution, and enhanced security

Network and server performance monitoringEnsure network, server, and storage reliability with AI-powered insights

IT incident managementEfficiently manage and resolve IT incidents while ensuring transparency

DNS and DHCP managementOptimize IP address and domain management

Cloud cost managementRight-size and take control of your cloud costs

IT analyticsConnect to your IT applications and visualize all facets of your IT

Cloud-native solutions for IT managementMonitor, manage, audit, and secure your multi-cloudand hybrid infrastructure

Business applications for ITBoost productivity and improve team collaboration

Custom solution builderBuild tailor-made apps to automate operations at your organization

Solutions for MSPsGrow your MSP business with scalable and secure IT management solutions

How to generate and export last logged on user report

Windows PowerShell

Steps to obtain the last logged on users using PowerShell:

Sample Windows PowerShell Script

ADAudit Plus

To obtain the report,

Related Resources

ADAudit Plus Trusted By

Meet all auditing and IT security needs with ADAudit Plus.

A single pane of glass for complete Active Directory Auditing and Reporting

Active Directory
management Manage, track, and secure Active Directory

Identity governance
and administrationOrchestrate user identity management and access controls for Zero Trust

Privileged access
managementControl and secure privileged access to critical enterprise systems

Enterprise and IT service
managementDeliver a consistent employee experience across business functions

Customer service
managementBuild a one-stop portal for customers with efficient account management

IT asset
managementCentralize and automate the complete IT asset life cycle

Network and server
performance monitoringEnsure network, server, and storage reliability with AI-powered insights

IT incident
managementEfficiently manage and resolve IT incidents while ensuring transparency

Cloud-native solutions for IT managementMonitor, manage, audit, and secure your multi-cloud
and hybrid infrastructure