You can use sys.dm_exec_requests DMV to list all requests. This view also contains a hash map of the SQL text – sql_handle, which can be passed to DMF sys.dm_exec_sql_text to get the query text:
SELECT REQUEST.session_id, REQUEST.start_time, QUERY.text
FROM sys.dm_exec_requests R......