Sage 300: Tracking User Login/Logout

I hope this blog post finds you well. I am writing to provide you with detailed information regarding the user login/logout tracking feature in Sage 300 ERP 2023 and the specific program or table where this data is captured.

Sage 300 ERP 2023 does include robust functionality to track when a user logs in or out of the application. This feature allows system administrators and auditors to monitor user activity and maintain an audit trail of user sessions within the ERP system.

In Sage 300 ERP 2023-Product Update 1, the user login/logout data is captured and stored within the underlying Microsoft SQL database. Specifically, the login/logout information is typically recorded in the ASAUDT table within the Sage 300 ERP database. This table is specifically designed to store the relevant details related to user login and logout activities.

Here is a brief overview of the specific table(s) within Microsoft SQL where the data is captured:

1. ASAUDT: This table stores information about user logins, including the user's login ID, the date and time of login, the workstation or device from which the login occurred, and additional details such as the IP address, if available and captures the details related to when a user logs out of the Sage 300 ERP 2023 application.

This table is part of the core Sage 300 ERP database structure and is accessible through SQL queries or database management tools compatible with Microsoft SQL.

It is important to note that the specific configuration and database structure may vary based on individual setups and customizations. Therefore, I recommend consulting your Sage Business Partner to confirm the exact table names and structure within your Sage 300 ERP 2023 installation.

Should you require further assistance or have any additional questions regarding the user login/logout tracking feature in Sage 300 ERP 2023 or any other related matter, please don't hesitate to reach out to our support team. We are here to provide you with the necessary guidance and support to ensure a seamless experience with our ERP solution.