SELECT p.[name] as [package_name],
       o.[name] as [event_name],
       c.[name] as [event_field_name],
       CASE
           WHEN c.[description] LIKE N'%milli%' THEN SUBSTRING(c.[description], CHARINDEX('milli', c.[description]),12)
           WHEN c.[description] LIKE N'%micro%' THEN SUBSTRING(c.[description], CHARINDEX('micro', c.[description]),12)
           ELSE 'Unknown'
        END as [duration_type],
       c.[type_name] as [field_type_name],
       c.[column_type] as [column_type]
FROM sys.dm_xe_objects o
    JOIN sys.dm_xe_packages p ON o.[package_guid] = p.[guid]
        JOIN sys.dm_xe_object_columns c ON o.[name] = c.[object_name]
WHERE o.[object_type] = 'event'
  AND c.[name] ='duration'
order by 1,2,3;