SCRM 2006 SCRS_NodePartition_OUTRIGGER_View

2006-09-10

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 `NULL` value indicates this row contains the current information.
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 `NULL` end date/time and `NULL` lineage end date. This is a foreign key into SC_LineageDimension_Table.
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: 0 Unknown 1 Readable 2 Writable 3 Read/write supported 4 Write once
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, `1059045376`.
PartitionType	nvarchar	Not Null	Type of the partition, using the following values: Unused 12-bit FAT Xenix Type 1 Xenix Type 2 16-bit FAT Extended Partition MS-DOS V4 Huge Installable File System PowerPC Reference Platform UNIX NTFS Win95 w/Extended Int 13 Extended w/Extended Int 13 Logical Disk Manager Unknown

See Also

Other Resources

SCRM 2006 MOM Views
SCRM 2006 Report Customization
SCRM 2006 SMS Views
SCRM 2006 Stored Procedures