SCRM 2006 SCRS_NodeSMSSystemRole_OUTRIGGER_View
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 |
| SystemRoleEndDateKey | smallint | Null values allowed | End of the time period that this row was known valid. A |
| SystemRoleEndDateLineageKey | int | Null values allowed | Key that identifies lineage of the DTS package that last identified this entry. A current entry has a |
| 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. |