get-the-fields-for-all-events.md

title	Get the Fields for All Events | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	database-engine
ms.topic	conceptual
helpviewer_keywords	extended events [SQL Server], getting fields xe
ms.assetid	4e4ee03f-5bca-42ed-a37c-db1c82e3aad2
author	mashamsft
ms.author	mathoma
manager	craigg

Get the Fields for All Events

Accomplishing this task involves using Query Editor in [!INCLUDEssManStudioFull].

After the statements in this procedure finish, the Results tab of Query Editor displays the following columns:

• package_name

• event_name

• event_field

• field_type

• column_type

You can use the preceding information when configuring event sessions that use the bucketing target. For more information, see SQL Server Extended Events Targets.

Before you Begin

Before you create a [!INCLUDEssNoVersion] Extended Events session, it is useful to get information about the fields associated with events.

To get the fields for all events using Query Editor

• In Query Editor, issue the following statements.

  select p.name package_name, o.name event_name, c.name event_field, c.type_name field_type, c.column_type 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'  
  order by package_name, event_name  
  

See Also

sys.dm_xe_objects (Transact-SQL)
sys.dm_xe_packages (Transact-SQL)