sys.server_event_session_fields (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns a row for each customizable column that was explicitly set on events and targets.

||
|-|
|Applies to: SQL Server ( SQL Server 2008 through current version).|

Column name Data type Description
event_session_id int The ID of the event session. Is not nullable.
object_id int The ID of the object this field is associated with. Is not nullable.
name sysname The name of the field. Is not nullable.
value sql_variant The value of the field. Is not nullable.

Permissions

Requires VIEW SERVER STATE permission on the server.

Remarks

This view has the following relationship cardinalities.

From To Relationship
sys.server_event_session_actions.event_session_id sys.server_event_sessions.event_session_id Many to one
sys.server_event_session_actions.event_id

sys.server_event_session_actions.object_id

sys.server_event_session_actions.event_session_id
sys.server_event_session_events.event_session_id

sys.server_event_session_events.event_id
Many to one
sys.server_event_session_actions.event_session_id

sys.server_event_session_actions.object_id
sys.server_event_session_targets.event_session_id

sys.server_event_session_targets.target_id
Many to one

See Also

Catalog Views (Transact-SQL)
Extended Events Catalog Views (Transact-SQL)
Extended Events