Extended Events - how can I query the location of File Target of an XE Session?

• VoldemarG

  Hall of Fame

  Points: 3883

  More actions

  January 17, 2022 at 2:59 pm

  Go to Answer

  #3973904

  If I know the XE Session name, is there a query to find out what file path is defined for File Target of the session?

  Likes to play Chess

• Alejandro Santana

  SSCommitted

  Points: 1835

  More actions

  January 17, 2022 at 3:17 pm

  Answer

  #3973912

  use the catalog views.

  in the view sys.server_event_session_fields the name of the values are filename and metadatafile, match them with sys.server_event_sessions i think the id.

  Regards,