| title | sys.dm_pdw_os_event_logs (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/07/2017 | |
| ms.prod | sql-non-specified | |
| ms.reviewer | ||
| ms.service | sql-data-warehouse | |
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | language-reference | |
| dev_langs |
|
|
| ms.assetid | a0daa8cf-72e2-4349-8be1-d3cc0f9b1e02 | |
| caps.latest.revision | 7 | |
| author | barbkess | |
| ms.author | barbkess | |
| manager | jhubbard |
[!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 Maximum System View Values section in the Minimum and Maximum Values (SQL Server PDW) topic.
SQL Data Warehouse and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)