SCRM 2006 SCRS_CollectionMemberNode_FACT_VIEW

SCRS_CollectionMemberNode_FACT_VIEW lists the managed nodes that are members of each SMS collection.

SCRS_CollectionMemberNode_FACT_VIEW

Column	Type	Constraint	Description
CollectionKey	int	Not Null	Foreign key that references a unique SMS collection in the Collection dimension.
CollectionMemberEndTimeKey	int	Null values allowed	End of the time period that this row was last known valid. A NULL value indicates this row contains the current information. A non-NULL value indicates the last time that this row was known to be valid.
CollectionMemberEndDateKey	smallint	Null values allowed	End of the time period that this row was last known valid. A NULL value indicates this row contains the current information. A non-NULL value indicates the last date that this row was known to be valid.
CollectionMemberEndDateTime	datetime	Null values allowed	End of the time period that this row was last known valid. A NULL value indicates this row contains the current information. A date value indicates the last date and time that this row was known to be valid.
CollectionMemberEndDateLineageKey	int	Null values allowed	Key that references the DTS lineage of the package that first detected that this SMS collection was deleted from the SMS site database.
CollectionMemberStartTimeKey	int	Not Null	Start of the time period that this row was last known valid. Indicates the time that the SMS collection entry was first inventoried by SMS.
CollectionMemberStartDateKey	smallint	Not Null	Start of the time period that this row was last known valid. Indicates the date that the SMS collection entry was first inventoried by SMS.
CollectionMemberStartDateTime	datetime	Not Null	Start of the time period that this row was known valid. Indicates the date and time that the SMS collection entry was first inventoried by SMS.
CollectionMemberStartDateLineageKey	int	Not Null	Key that references the DTS lineage of the package that first detected that this SMS collection entry was inserted into the SMS site database.
NodeKey	int	Not Null	Foreign key that references a unique managed node in the Managed Node dimension.

See Also

Other Resources

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