| title | sys.pdw_health_components (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/04/2017 | |
| ms.prod | sql-non-specified | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| ms.assetid | d5c7589b-09b0-4f12-ab84-feb3ec3fbaaa | |
| caps.latest.revision | 6 | |
| author | barbkess | |
| ms.author | barbkess | |
| manager | jhubbard |
[!INCLUDEtsql-appliesto-xxxxxx-xxxx-xxxx-pdw_md]
Stores information about all components and devices that exist in the system. These include hardware, storage devices, and network devices.
| Column Name | Data Type | Description | Range |
|---|---|---|---|
| component_id | int | Unique identifier of a component or device. Key for this view. |
NOT NULL |
| group_id | Int | The logical component group to which this component belongs. See sys.pdw_health_components (Parallel Data Warehouse). | NOT NULL |
| component_name | nvarchar(255) | Name of the component. | NOT NULL |
SQL Data Warehouse and Parallel Data Warehouse Catalog Views