For details about SQL Server Auditing, please refer to the following article.
https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine
https://www.codeproject.com/articles/166264/audits-on-ms-sql-server
Alternatively, you may try this automated solution ( https://www.lepide.com/lepideauditor/sql-server-auditing.html ).