SCRM 2006 SCRS_NodeChange_Fact_View
SCRS_NodeChange_Fact_View lists the managed node configuration changes.
SCRS_NodeChange_Fact_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| NodeChangeTableKey | int | Not Null | Foreign key in the outrigger table or Managed Node dimension table. The actual table is defined by NodeChangeTypeKey.NodeChangeTable. |
| NodeChangeTimeKey | int | Not Null | The time that a change on a managed node occurred. |
| NodeChangeDateKey | smallint | Not Null | The date that a change on a managed node occurred. |
| NodeChangeDateTime | datetime | Not Null | The date and time that a change on a managed node occurred. |
| NodeChangeLineageKey | int | Not Null | References the DTS lineage of the package that first detected that an attribute of this node had changed. |
| NodeKey | int | Not Null | Foreign key that references a unique managed node in the Managed Node dimension. |
| NodeChangeTypeKey | int | Not Null | Foreign key to |
| LocationKey | int | Not Null | Foreign key that references a unique node location in the Node Location dimension. |
| SMSSiteKey | int | Not Null | Foreign key that references a unique SMS site in the SMS Site dimension. |
| UserKey | int | Not Null | Foreign key that references a unique user in the User dimension. |