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 |
| CollectionMemberEndDateKey | smallint | Null values allowed | End of the time period that this row was last known valid. A |
| CollectionMemberEndDateTime | datetime | Null values allowed | End of the time period that this row was last known valid. A |
| 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. |