Forum Discussion

Alktor's avatar
Alktor
Copper Contributor
Jul 05, 2024

Extended Event with app_name doesn't work properly

Hello,   When I create an extended event to capture all the SELECT on the instance, it works : CREATE EVENT SESSION [YourSession] ON SERVER ADD EVENT sqlserver.sql_statement_completed( ACTION(sq...
rpi_dwillis77's avatar
rpi_dwillis77
Iron Contributor
Dec 20, 2024

Hello,

I'm having the exact same issue when trying to capture login events - if I include the AppName field in the session, I get no results. If I remove it, I get results as expected.

This is on SQL 2019. If anyone knows why this is happening, some insight would be much appreciated!

Best regards

  • SQLSimon's avatar
    SQLSimon
    Occasional Reader
    May 14, 2026

    Hi

    I'm getting the same problem when using the "error_reported" event.  If I include the "AppName" action, it stops recording events.  In fact, there are 2 "AppName" actions, one with a description of "AppName without the full app uri", and one with "Application  name without the full app uri".  If I include either action, it stops recording errors.

    When I remove them it starts working.

    This is on a SQL Managed Instance.

    Regards

    Simon