SCRM 2006 SC_NodeLogon_OUTRIGGER_View
SC_NodeLogon_OUTRIGGER_View lists the history of user logons for a managed node.
SC_NodeLogon_OUTRIGGER_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| NodeLogonKey | int | Not Null | Key that uniquely identifies a logon 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. |
| UserKey | int | Null values allowed | Key that identifies the user that logged on to the managed node. This is a foreign key into SC_UserDimension_Table. |
| LogonEndTimeKey | int | Null values allowed | End of the time period that this row was known valid. A |
| LogonEndDateKey | smallint | Null values allowed | End of the time period that this row was known valid. A |
| LogonEndDateLineageKey | int | Null values allowed | Key that identifies lineage of the DTS package that last identified this entry. A current entry will have a |
| LogonStartTimeKey | int | Not Null | Start of the time period that this row was known valid. Indicates the date that item was first inventoried by SMS. |
| LogonStartDateKey | smallint | Not Null | Start of the time period that this row was known valid. Indicates the date that item was first inventoried by SMS. |
| LogonStartDateLineageKey | 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. |
| LogonUserName | nvarchar | Null values allowed | Domain name and user name of the currently logged-on user. |