Hello @Saiganesh_Tawade!
Here are our docs on accessing audit logs for Retool apps 
These features are available for users on our Enterprise plan with some also for Business plan users.
Customers can stream their audit logs to DataDog and if they're on cloud, export them to CSV.
Access to the audit logs SQL table are only available on self-hosted deployments.
Retool logs events to the audit_trail_events table in the postgres database of the deployment instance. You can create a PostgreSQL resource if you want to build apps and workflows to query audit log data. This could then be combined with a Slack Resource for sending the data via Queries.
For your question on how many days for data retention, I am not sure but can double check that!