SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

WITH xe(Events) AS (
/*
    SELECT CAST(xest.target_data as xml)
    FROM sys.dm_xe_session_targets xest  
    JOIN sys.dm_xe_sessions xes ON xes.address = xest.event_session_address  
    WHERE xest.target_name = 'ring_buffer' AND xes.name = 'FindBlockers'  
*/
    SELECT CAST(N'<RingBufferTarget truncated="0" processingTime="0" totalEventsProcessed="20" eventCount="20" droppedCount="0" memoryUsed="42024">
  <event name="rpc_completed" package="sqlserver" timestamp="2022-02-06T12:25:54.370Z">
    <data name="cpu_time">
      <type name="uint64" package="package0" />
      <value>0</value>
    </data>
    <data name="duration">
      <type name="uint64" package="package0" />
      <value>304</value>
    </data>
    <data name="physical_reads">
      <type name="uint64" package="package0" />
      <value>0</value>
    </data>
    <data name="logical_reads">
      <type name="uint64" package="package0" />
      <value>6</value>
    </data>
    <data name="writes">
      <type name="uint64" package="package0" />
      <value>0</value>
    </data>
    <data name="result">
      <type name="rpc_return_result" package="sqlserver" />
      <value>0</value>
      <text>OK</text>
    </data>
    <data name="row_count">
      <type name="uint64" package="package0" />
      <value>1</value>
    </data>
    <data name="connection_reset_option">
      <type name="connection_reset_option" package="sqlserver" />
      <value>0</value>
      <text>None</text>
    </data>
    <data name="object_name">
      <type name="unicode_string" package="package0" />
      <value>sp_executesql</value>
    </data>
    <data name="statement">
      <type name="unicode_string" package="package0" />
      <value>exec sp_executesql N''SELECT
session.name AS [Name],
''''XEStore[@Name='''' + quotename(CAST(SERVERPROPERTY(N''''ServerName'''') AS sysname),'''''''''''''''') + '''']'''' + ''''/Session[@Name='''' + quotename(session.name,'''''''''''''''') + '''']'''' AS [Urn],
session.startup_state AS [AutoStart],
running.create_time AS [StartTime],
(CASE WHEN (running.create_time IS NULL) THEN 0 ELSE 1 END) AS [IsRunning]
FROM
sys.server_event_sessions AS session
LEFT OUTER JOIN sys.dm_xe_sessions AS running ON running.name = session.name
WHERE
(session.name=@_msparam_0)and((CAST(SERVERPROPERTY(N''''ServerName'''') AS sysname)=@_msparam_1))
ORDER BY
[Name] ASC'',N''@_msparam_0 nvarchar(4000),@_msparam_1 nvarchar(4000)'',@_msparam_0=N''Sp_Mon'',@_msparam_1=N''WIN-9SOQOAAQ7AK''</value>
    </data>
    <data name="data_stream">
      <type name="binary_data" package="package0" />
      <value />
    </data>
    <data name="output_parameters">
      <type name="xml" package="package0" />
      <value />
    </data>
    <action name="nt_username" package="sqlserver">
      <type name="unicode_string" package="package0" />
      <value>WIN-9SOQOAAQ7AK\Administrator</value>
    </action>
    <action name="database_id" package="sqlserver">
      <type name="uint16" package="package0" />
      <value>1</value>
    </action>
  </event>
</RingBufferTarget>
' AS xml)
)
SELECT
  timestamp    = x1.evnt.value('@timestamp','datetimeoffset'),
  cpu_time     = x1.evnt.value('(data[@name="cpu_time"]/value/text())[1]','bigint'),
  object_name  = x1.evnt.value('(data[@name="object_name"]/value/text())[1]','sysname')
FROM xe
CROSS APPLY xe.Events.nodes('RingBufferTarget/event') x1(evnt)

timestamp	cpu_time	object_name
2022-02-06 12:25:54.3700000 +00:00	0	sp_executesql