User Logon History
This page explains how to review user login activity in xAssets. Monitoring logon history helps with security auditing, identifying inactive accounts, and troubleshooting access issues.
Where to Find Logon Information
User logon history is available in two places:
1. Users List -- Last Logon Column
The Admin > Users screen shows each user's last logon date directly in the list. This gives a quick overview of recent activity without running a separate report.
Use this to:
- Identify users who have not logged in recently (candidates for account cleanup).
- Confirm that a specific user has successfully logged in after account setup or password reset.
- Spot accounts that should be disabled (e.g., employees who have left but still have active accounts).
2. Logon Activity Query
For a detailed log of all logins, run the Logon Activity query. This provides a full history that can be searched, sorted, filtered, and exported to Excel.
To run the Logon Activity query:
- Navigate to Admin > Users.
- Select the Logon Activity query from the available queries, or search for it in Admin > Queries.
- The results show each login event with the username, date, time, and session information.
The Logon Activity query includes a Non-Admin variant that filters out administrative and system user logins. This variant is useful when you want to review only end-user activity without the noise of automated or admin sessions.
Common Use Cases
| Use Case | What to Look For |
|---|---|
| Security audit | Logins at unusual times, logins from unexpected locations, multiple failed attempts |
| Inactive account cleanup | Users with no login in the past 90 days; consider disabling these accounts |
| License management | Count of distinct users who logged in during a period, to verify licence usage |
| Troubleshooting | Confirm whether a user reporting access issues has actually reached the login screen |
Tip: Export the Logon Activity query to Excel for reporting to management or compliance teams. The export includes all columns and can be filtered further in the spreadsheet.
Warning: Logon history records are written at login time. If the database is in read-only mode, login events will not be recorded even though users can still log in and view data.
Related Articles
- Users — managing user accounts
- Users Menu Options — operations like logoff and unlock
- User Groups — controlling what users can do once logged in