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 `NodeChangeType` dimension that identifies type of change associated with the node; for example, CPU, operating system, disk, etc.
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.