sys.dm_pdw_os_event_logs (Transact-SQL)

APPLIES TO: noSQL Server noAzure SQL Database noAzure SQL Data Warehouse yesParallel Data Warehouse

Holds information regarding the different Windows Event logs on the different nodes.

Column Name Data Type Description Range
pdw_node_id int Appliance node this log is from.

pdw_node_id and log_name form the key for this view.
log_name nvarchar(255) Windows event log name.

pdw_node_id and log_name form the key for this view.
log_source nvarchar(255) Windows event log source name.
event_id int ID of the event. Not unique.
event_type nvarchar(255) Type of the event, identifying severity. 'Information', 'Warning', 'Error'
event_message nvarchar(4000) Details of the event.
generate_time datetime Time the event was created.
write_time datetime Time the event was actually written to the log.

For information about the maximum rows retained by this view, see the Metadata section in the Capacity limits topic.

See Also

SQL Data Warehouse and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)