Do we have any maximum limit for Admin activity "Log Entry Lifetime/Days" in Magento2.3?
Can we access one year old "Admin activity Log data" from Magento DB?
You can use this extension for admin activity, it gives you information for new and old data (1+ year) in admin. Admin Activity Logger is developed to improve the security of your store and provide you clear visibility of all the actions performed in your admin. It protects your admin from malicious attacks and gives you full control over your Magento 2 backend.
The following link Magento 2 Admin activity log would be useful.
In Magento 2.3, the "Admin activity Log Entry Lifetime/Days" configuration determines how long admin activity log entries are retained in the database. By default, this setting is usually configured to 180 days. However, you can adjust this value based on your specific needs. If you set it to a longer duration, such as one year, you should be able to access admin activity log data that is up to a year old from the Magento database. Keep in mind that retaining logs for an extended period may impact the database size, so it's essential to balance your retention needs with database performance considerations. To modify this setting, navigate to your Magento admin panel, go to Stores > Configuration > Advanced > Admin > Admin Actions Logging.
In Magento 2.3, the "Admin activity Log Entry Lifetime/Days" configuration does not have an explicitly stated maximum limit within the system's user interface or official documentation. This means that theoretically, you can set it to any integer value.