Application Name in Extended Events

---

Vasavi wrote:

How about identifying the excel application - does anyone know how to make it visible or identifiable as the application name for queries that are executing using it. 

---

So it's the same as SSRS, your users would need to go into the connection properties in Excel and edit the connection string to add "Application Name=Excel". Unfortunately Excel does not automatically insert this when making a new connection, so it would be up to your users to remember to do this every time they make a new pivot table, which is not really practical.

I have done things in the past where we supplied the users with an ODC file where which they could open to create a new Excel file with a new pivot table and you could insert the "Application Name=" setting in there. But if you have existing reports without the "Application Name=" setting in the connection string this will not fix those.