SCRM 2006 SCRS_NodeSMSSystemRole_OUTRIGGER_View

2006-09-10

SCRS_NodeSMSSystemRole_OUTRIGGER_View lists SMS system role information for a managed node.

SCRS_NodeSMSSystemRole_OUTRIGGER_View

Column	Type	Constraint	Description
NodeSystemRoleKey	int	Not Null	Key that uniquely identifies an SMS system role associated with the managed node referenced by NodeKey.
NodeKey	int	Not Null	Key that identifies the managed node associated with this entry. This is a foreign key into SC_ManagedNodeDimension_Table.
SystemRoleEndTimeKey	int	Null values allowed	End of the time period that this row was known valid. A `NULL` value indicates this row contains the current information.
SystemRoleEndDateKey	smallint	Null values allowed	End of the time period that this row was known valid. A `NULL` value indicates this row contains the current information.
SystemRoleEndDateLineageKey	int	Null values allowed	Key that identifies lineage of the DTS package that last identified this entry. A current entry has a `NULL` end date and time and `NULL` lineage end date. This is a foreign key into SC_LineageDimension_Table.
SystemRoleStartTimeKey	int	Not Null	Start of the time period that this row was known valid. Indicates the date that the item was first inventoried by SMS.
SystemRoleStartDateKey	smallint	Not Null	Start of the time period that this row was known valid. Indicates the date that the item was first inventoried by SMS.
SystemRoleStartDateLineageKey	int	Not Null	Key that identifies lineage of the DTS package that first identified this entry. This is a foreign key into SC_LineageDimension_Table.
SystemRoleName	nvarchar	Null values allowed	Name of the SMS role assigned to this node.
SystemRoleShareName	nvarchar	Null values allowed	Name of the share if the SMS role is associated with a specific share: Distribution Point or Client Access Point.
SystemRoleSMSSiteKey	int	Null values allowed	Identifies the SMS site associated with this entry. This is a foreign key into SC_SMSSiteDimension_Table.

See Also

Other Resources

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