SELECT
  timestamp,
  rec.value('/Record[1]/AppDomain[1]/@address', 'nvarchar(10)') as address,
  rec.value('/Record[1]/AppDomain[1]/@dbId', 'nvarchar(4)') as dbid,
  rec.value('/Record[1]/AppDomain[1]/@ownerId', 'nvarchar(5)') as ownerid,
  rec.value('/Record[1]/AppDomain[1]/@type', 'nvarchar(32)') as type,
  rec.value('/Record[1]/AppDomain[1]/State[1]', 'nvarchar(32)')as state
FROM (
      SELECT timestamp, cast(record as xml) as rec 
      FROM sys.dm_os_ring_buffers 
      WHERE ring_buffer_type = 'RING_BUFFER_CLRAPPDOMAIN'
      ) T(timestamp, rec) 
ORDER BY timestamp DESC