Use the following query:

see the output query and the tables in the query.

select req.session_id, ses.login_name,req.blocking_session_id,sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time

from sys.dm_exec_requests req left join sys.dm_exec_sessions ses on req.session_id= ses.session_id

cross apply sys.dm_exec_sql_text(sql_handle) as sqltext