sys.pdw_health_components (Transact-SQL)

Applies to: Analytics Platform System (PDW)

This view stores information about all components and devices that exist in the system. These components and devices 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_component_groups (Parallel Data Warehouse).	NOT NULL
component_name	nvarchar(255)	Name of the component.	NOT NULL

See Also

Azure Synapse Analytics and Parallel Data Warehouse Catalog Views