Share via


SCRM 2006 SC_NodeNetworkClient_OUTRIGGER_View

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