To get the info in a query, try using this dynamic mgmt view: sys.dm_exec_requests.

For instance, to get all the spid's that are currently blocked:

SELECT *

FROM sys.dm_exec_requests

WHERE wait_time > 0

AND blocking_session_id != 0