WITH
ss AS
(
SELECT session_id 
FROM   sys.dm_exec_requests  AS r
WHERE  DB_NAME(r.database_id) NOT IN ('master', 'model', 'msdb', 'tempdb')
       AND r.database_id < 32767
       AND r.session_id <> @@SPID
       AND r.blocking_session_id > 0
UNION 
SELECT  blocking_session_id 
FROM   sys.dm_exec_requests  AS r
WHERE  blocking_session_id > 0

)
SELECT * 
FROM   sys.dm_exec_sessions AS s
       LEFT OUTER JOIN sys.dm_exec_requests  AS r
          ON s.session_id = r.session_id
       JOIN ss 
          ON ss.session_id = s.session_id;