Forum Discussion
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...
Did you try sql server.client_app_name instead of SQLSatellite.AppName?
sqlserver.client_app_name somes from TDS session metadata, connectionstring, SSMS, application drivers. This correct one for auditing or tracing.
SQLSatellite is related to SQL server Machine Learning Services or external scripting infrastructure. It is not intended as the generic client application name for normal database sessions.
That explains why XE session stopped returning data.