sys.pdw_health_component_properties (Transact-SQL)

Applies to: Analytics Platform System (PDW)

Stores properties that describe a device. Some properties show device status and some properties describe the device itself.

Column Name	Data Type	Description	Range
property_id	int	Unique identifier of the property of a component. property_id and component_id form the key for this view.	NOT NULL
component_id	int	The ID of the component. See sys.pdw_health_components (Transact-SQL). property_id and component_id form the key for this view.	NOT NULL
property_name	nvarchar(255)	Name of the property.	NOT NULL
physical_name	nvarchar(32)	Property name as defined by the manufacturer.	NOT NULL
is_key	bit	Determines whether the device instance is unique or not unique.	NOT NULL 0 - Device instance is unique. 1 - Device instance is not unique.

See Also