I want to have the ability in audit logs which will give me the application name for any query fired to give details of client application.
MSDN says that they support it from SQL Server 2017. I am able to see it when I run query on audit logs using "fn_get_audit_file" function. But I dont see that data when I review the audit logs in SSMS. So I was wondering whether I missing something when trying to configure the audit specification or something else.