Hi @sakuraime , welcome to Microsoft QnA forum.
You can run below query to get all the required information:
select
r.session_id,
s.login_name,
c.client_net_address,
s.host_name,
s.program_name,
st.text, s.status
from sys.dm_exec_requests r
inner join sys.dm_exec_sessions s
on r.session_id = s.session_id
left join sys.dm_exec_connections c
on r.session_id = c.session_id
outer apply sys.dm_exec_sql_text(r.sql_handle) st
where client_net_address is not null and text is not null and s.status = 'running'
Reference Article: Get username and/or IP address responsible for a query
Please let us know if this helps.
----------
If answer helps, please mark it as 'Accept Answer'