Skip to content

Latest commit

 

History

History
38 lines (32 loc) · 1.86 KB

File metadata and controls

38 lines (32 loc) · 1.86 KB
title sys.dm_pdw_os_event_logs (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/07/2017
ms.prod sql
ms.technology system-objects
ms.reviewer
ms.topic language-reference
dev_langs
TSQL
ms.assetid a0daa8cf-72e2-4349-8be1-d3cc0f9b1e02
author stevestein
ms.author sstein
monikerRange >= aps-pdw-2016 || = sqlallproducts-allversions

sys.dm_pdw_os_event_logs (Transact-SQL)

[!INCLUDEtsql-appliesto-xxxxxx-xxxx-xxxx-pdw-md]

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)