declare @xml xml

select @xml = target_data
from sys.dm_xe_session_targets
join sys.dm_xe_sessions on event_session_address = address
where name = 'system_health'

if (substring(cast (serverproperty('ProductVersion') as nvarchar(20)), 1, 5) = '10.00' and cast(substring(cast (serverproperty('ProductVersion') as nvarchar(20)), 7, 4) as int) < 2757)
	or
	(substring(cast (serverproperty('ProductVersion') as nvarchar(20)), 1, 5) = '10.50' and cast(substring(cast (serverproperty('ProductVersion') as nvarchar(20)), 7, 4) as int) < 1702)
begin
	select cast (
		replace (
			replace (
				replace (
					replace (
						replace (
							replace(replace(replace(xev.xv.value ('(data/value)[1]', 'nvarchar(max)'), ' ','!£$%&'),'%&!£$',''),'!£$%&',' '),
							'<victim-list', '<deadlock><victim-list'),
						'<victim-list/>', '<victim-list>'),
					'<process-list>', '</victim-list><process-list>'),
				char(10), ''),
			'"> <victimProcess', '" /> <victimProcess')
		as xml)
	from
	(select @xml as tg) AS Data
	cross apply tg.nodes ('RingBufferTarget/event[@name="xml_deadlock_report"]') as xev (xv)
end
else
begin
	select cast(xev.xv.value ('(data/value)[1]', 'nvarchar(max)') as xml)
	from
	(select @xml as tg) AS Data
	cross apply tg.nodes ('RingBufferTarget/event[@name="xml_deadlock_report"]') as xev (xv)
end