SCRM 2006 SC_NodeNetworkClient_OUTRIGGER_View

Article
09/10/2006

SC_NodeNetworkClient_OUTRIGGER_View lists hardware inventory for the network clients on a managed node.

SC_NodeNetworkClient_OUTRIGGER_View

Column	Type	Constraint	Description
NodeNetworkClientKey	int	Not Null	Key that uniquely identifies a network client 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.
NetworkClientEndTimeKey	int	Null values allowed	End of the time period that this row was known to be valid. A `NULL` value indicates this row contains the current information.
NetworkClientEndDateKey	smallint	Null values allowed	End of the time period that this row was known to be valid. A `NULL` value indicates this row contains the current information.
NetworkClientEndDateLineageKey	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/time and NULL lineage end date. This is a foreign key into SC_LineageDimension_Table.
NetworkClientStartTimeKey	int	Not Null	Start of the time period that this row was known to be valid. Indicates date that item was first inventoried by SMS.
NetworkClientStartDateKey	smallint	Not Null	Start of the time period that this row was known to be valid. Indicates date that item was first inventoried by SMS.
NetworkClientStartDateLineageKey	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.
NetworkClientName	nvarchar	Null values allowed	Network name of the network client running on a Windows system—for example, `Microsoft Windows Network`.
NetworkClientDescription	nvarchar	Null values allowed	Description of the network client.
NetworkClientManufacturer	nvarchar	Null values allowed	Name of the manufacturer of the network client running on the Windows operating system.

See Also

Other Resources

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