Way back in October (2014) I published the post: XML, Glad that is over (yeah, I know such a good title). In that post I published a script built from researching how to get the deadlock report out of the Extended Event system_health session. Think of this session like the default trace of SQL Server 2005, but way cooler. Anyway…

It was brought up to me recently on an answer I provided on DBA.StackExchange.com, that I needed a 2014 version. When in fact this is required starting on SQL Server 2012 because the Event XML output changed started in this release. You can find an excellent write-up of this from Jonathan Kehayias here.

I moved the script to my GitHub repository, and provided an update so it can be run on SQL Server 2012 and higher. The comments now include what has to be changed to make it run on SQL Server 2008.

Enjoy.