Find the all active user connections and internal tasks

SELECT * FROM sys.dm_exec_sessions
WHERE is_user_process =1
AND session_id <>@@SPID