SCRM 2006 SCRS_NodePartition_OUTRIGGER_View
SCRS_NodePartition_OUTRIGGER_View lists hardware inventory for the logical partitions on a managed node.
SCRS_NodePartition_OUTRIGGER_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| NodePartitionKey | int | Not Null | Key that uniquely identifies a disk partition associated with the managed node referenced by NodeKey. |
| NodeKey | int | Not Null | Key that identifies the managed node associated with this entry. This is a foreign key into SC_ManagedNodeDimension_Table. |
| PartitionEndTimeKey | int | Null values allowed | End of the time period that this row was known valid. A |
| PartitionEndDateKey | smallint | Null values allowed | End of the time period that this row was known valid. A NULL value indicates this row contains the current information. |
| PartitionEndDateLineageKey | int | Null values allowed | Key that identifies lineage of the DTS package that last identified this entry. A current entry has a |
| PartitionStartTimeKey | int | Not Null | Start of the time period that this row was known valid. Indicates the date that item was first inventoried by SMS. |
| PartitionStartDateKey | smallint | Not Null | Start of the time period that this row was known valid. Indicates the date that item was first inventoried by SMS. |
| PartitionStartDateLineageKey | int | Not Null | Key that identifies lineage of the DTS package that first identified this entry. This is a foreign key into SC_LineageDimension_Table. |
| PartitionName | nvarchar | Not Null | Label by which the partition is known. |
| PartitionAccess | nvarchar | Not Null | Media access available, using the following values:
|
| PartitionBootable | int | Null values allowed | Indicator for whether the computer can be booted from the partition. |
| PartitionBootPartition | int | Null values allowed | Indicator for whether this is the active partition. The operating system uses the active partition when starting from a hard disk. |
| PartitionPrimaryPartition | int | Null values allowed | Indicator for whether this is the primary disk partition. |
| PartitionSize | bigint | Null values allowed | Total size of the partition in bytes—for example, |
| PartitionType | nvarchar | Not Null | Type of the partition, using the following values:
|