SCRM 2006 SC_NodeLogon_OUTRIGGER_View

2006-09-10

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 `NULL` value indicates this row contains the current information.
LogonEndDateKey	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.
LogonEndDateLineageKey	int	Null values allowed	Key that identifies lineage of the DTS package that last identified this entry. A current entry will have a `NULL` end date and time and `NULL` lineage end date. This is a foreign key into SC_LineageDimension_Table.
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.

See Also

Other Resources

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