SCRM 2006 SC_NodeTape_OUTRIGGER_View

SC_NodeTape_OUTRIGGER_View lists hardware inventory for the tape drives on a managed node.

SC_NodeTape_OUTRIGGER_View

Column	Type	Constraint	Description
NodeTapeKey	int	Not Null	Key that uniquely identifies a tape device 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.
TapeEndTimeKey	int	Null values allowed	End of the time period that this row was known to be valid. A `NULL` value indicates this row contains the current information.
TapeEndDateKey	smallint	Null values allowed	End of the time period that this row was known to be valid. A `NULL` value indicates this row contains the current information.
TapeEndDateLineageKey	int	Null values allowed	Key that identifies lineage of the DTS package that last identified this entry. A current entry will have a `NULL` end date/time and `NULL` lineage end date. This is a foreign key into SC_LineageDimension_Table.
TapeStartTimeKey	int	Not Null	Start of the time period that this row was known to be valid. Indicates date that item was first inventoried by SMS.
TapeStartDateKey	smallint	Not Null	Start of the time period that this row was known to be valid. Indicates date that item was first inventoried by SMS.
TapeStartDateLineageKey	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.
TapeName	nvarchar	Null values allowed	Label by which the tape device is known.