SCRM 2006 SCRS_NodeLocationAndAssociation_FACT_View

SCRS_NodeLocation_Dimension_View lists the association between a node, its location, and the SMS site and the user or computer owner. It also contains the offset between the computer's local time and Coordinated Universal Time (Greenwich Mean Time).

SCRS_NodeLocationAndAssociation_Dimension_View

Column	Type	Constraint	Description
NodeLocationAndAssocationEndTimeKey	int	Null values allowed	End of the time period that this row was 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.
NodeLocationAndAssocationEndDateKey	smallint	Null values allowed	End of the time period that this row was 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.
NodeLocationAndAssocationEndDateTime	datetime	Null values allowed	End of the time period that this row was 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.
NodeLocationAndAssocationEndDateLineageKey	int	Null values allowed	Key that references the DTS lineage of the package that first detected that this node location had been deleted.
NodeLocationAndAssocationStartTimeKey	int	Not Null	Start of the time period that this row was known to be valid. Indicates time that the node location was detected as input.
NodeLocationAndAssocationStartDateKey	smallint	Not Null	Start of the time period that this row was known to be valid. Indicates date that the node location was detected as input.
NodeLocationAndAssocationStartDateTime	datetime	Not Null	Start of the time period that this row was known to be valid. Indicates date and time that the node location was first detected as input.
NodeLocationAndAssocationStartDateLineageKey	int	Not Null	Key that references the DTS lineage of the package that first detected that this node location had been inserted.
LocationKey	int	Not Null	Foreign key that references a unique node location in the Node Location dimension.
NodeKey	int	Not Null	Foreign key that references a unique managed node in the Managed Node dimension.
UserKey	int	Not Null	Foreign key that references a unique user in the User dimension.
SMSSiteKey	int	Not Null	Foreign key that references a unique SMS site in the SMS Site dimension.
TimeZoneOffset	int	Null values allowed	Offset from GMT for the time zone in which the node resides.

See Also

Other Resources

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