Dead lock Information from XML to Table Format

Here with a script to convert the XML dead lock file to a table format as we DBA love the table fundamentally...

declare @deadlock xml
set @deadlock = 'dead lock xml content'

select 
 [PagelockObject] = @deadlock.value('/deadlock-list[1]/deadlock[1]/resource-list[1]/pagelock[1]/@objectname', 'varchar(200)'),
 [DeadlockObject] = @deadlock.value('/deadlock-list[1]/deadlock[1]/resource-list[1]/objectlock[1]/@objectname', 'varchar(200)'),
 [KeylockObject] = Keylock.Process.value('@objectname', 'varchar(200)'),
 [Index] = Keylock.Process.value('@indexname', 'varchar(200)'),
 [IndexLockMode] = Keylock.Process.value('@mode', 'varchar(5)'),
 [RIDLock] = RIDLock.Process.value('@objectname', 'varchar(200)'),
 [RIDLockMode] = RIDLock.Process.value('@mode', 'varchar(5)'),
 [Victim] = case when Deadlock.Process.value('@id', 'varchar(50)') = @deadlock.value('/deadlock-list[1]/deadlock[1]/@victim', 'varchar(50)') then 1 else 0 end,
 [Procedure] = Deadlock.Process.value('executionStack[1]/frame[1]/@procname[1]', 'varchar(200)'),
 [LockMode] = Deadlock.Process.value('@lockMode', 'varchar(3)'),
 [Code] = Deadlock.Process.value('executionStack[1]/frame[1]', 'varchar(1000)'),
 [ClientApp] = Deadlock.Process.value('@clientapp', 'varchar(100)'),
 [HostName] = Deadlock.Process.value('@hostname', 'varchar(20)'),
 [LoginName] = Deadlock.Process.value('@loginname', 'varchar(20)'),
 [TransactionTime] = Deadlock.Process.value('@lasttranstarted', 'datetime'),
 [InputBuffer] = Deadlock.Process.value('inputbuf[1]', 'varchar(1000)')
 from @deadlock.nodes('/deadlock-list/deadlock/process-list/process') as Deadlock(Process)
      LEFT JOIN @deadlock.nodes('/deadlock-list/deadlock/resource-list/keylock') as Keylock(Process)
        ON Keylock.Process.value('owner-list[1]/owner[1]/@id', 'varchar(50)') = 
           Deadlock.Process.value('@id', 'varchar(50)')
      LEFT JOIN @deadlock.nodes('/deadlock-list/deadlock/resource-list/ridlock') as RIDLock(Process)
        ON RIDLock.Process.value('owner-list[1]/owner[1]/@id', 'varchar(50)') = 
           Deadlock.Process.value('@id', 'varchar(50)')