How to get all SQL extended event sessions on server?

Question

I want to query on the server for all extended event sessions, with state : started and stopped.

This query is returning only the sessions with state = started :

select [Name], create_time from sys.dm_xe_sessions

Can you please provide a way (if possible) which returns all the extended event sessions on the server ?

Answer 1

You should look in sys.server_event_sessions table:

select * from sys.server_event_sessions

sys.dm_xe_sessions returns information about an active extended events session only.