Home Forums SQL Server 2017 SQL Server 2017 - Administration application_name is not available in audit logs in SQL Server 2017 RE: application_name is not available in audit logs in SQL Server 2017

  • December 8, 2017 at 10:37 am

    #1971405

    ajeet.s.chouhan - Tuesday, December 5, 2017 11:47 PM

    I am looking for a way to fetch client application name in audit logs in SQL Server. As per the MSDN page, it should be available from SQL Server 2017 on-wards.

    https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-get-audit-file-transact-sql

    I have created a database level audit specification for select and insert and I want to determine which application is executing those queries.

    Any help around this topic is appreciated.

    Are you querying the log using sys.fn_get_audit_file or are you trying to do the View Audit Logs in SSMS?
    Use the query - using SSMS has different issues and can be problematic.

    Sue