SCRM 2006 SCRS_NodeNetCard_OUTRIGGER_View

SCRS_NodeNetCard_OUTRIGGER_View lists hardware inventory for the network cards on a managed node.

SCRS_NodeNetCard_OUTRIGGER_View

Column	Type	Constraint	Description
NodeNetCardKey	int	Not Null	Key that uniquely identifies a network card associated with the managed node referenced by NodeKey.
NodeKey	int	Null values allowed	Key that identifies the managed node associated with this entry. This is a foreign key into SC_ManagedNodeDimension_Table.
NetCardEndTimeKey	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.
NetCardEndDateKey	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.
NetCardEndDateLineageKey	int	Not Null	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.
NetCardStartTimeKey	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.
NetCardStartDateKey	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.
NetCardStartDateLineageKey	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.
NetCardAdapterType	nvarchar	Not Null	Network medium in use, using the following values: Note The Windows NT property may not be applicable to all types of network adapters listed within this class. Ethernet 802.3 Token Ring 802.5 Fiber Distributed Data Interface (FDDI) Wide Area Network (WAN) LocalTalk Ethernet using DIX header format ARCNET "ARCNET (878.2) "ATM Wireless "Infrared Wireless Bpc CoWan 1394
NetCardDefaultIPGateway	nvarchar	Not Null	Array of IP addresses of default gateways that the computer system uses—for example, 192.168.12.1 192.168.46.1.
NetCardDHCPEnabled	int	Null values allowed	If TRUE, the DHCP server automatically assigns an IP address to the computer system when establishing a network connection.
NetCardDHCPServer	nvarchar	Not Null	IP address of the DHCP server—for example, ""10.55.34"".
NetCardIPAddress	nvarchar	Not Null	Array of all IP addresses associated with the current network adapter—for example, 172.16.22.0.
NetCardIPEnabled	int	Not Null	If TRUE, TCP/IP is bound and enabled on this network adapter.
NetCardIPSubnet	nvarchar	Null values allowed	Array of all the subnet masks associated with the current network adapter—for example, 255.255.0.
NetCardMACAddress	nvarchar	Not Null	Media Access Control (MAC) address of the network adapter—for example, 00:80:C7:8F:6C:96. A MAC address is assigned by the manufacturer to uniquely identify the network adapter.
NetCardManufacturer	nvarchar	Not Null	Name of the network adapter manufacturer—for example, 3COM.
NetCardMaxSpeed	nvarchar	Not Null	Maximum speed for the network adapter card, in bits per second.
NetCardName	nvarchar	Not Null	Name of the network adapter.
NetCardServiceName	nvarchar	Not Null	Service name of the network adapter, usually shorter than the full product name—for example, Elnkii.
NetCardSpeed	nvarchar	Not Null	Estimate of the current bandwidth in bits per second. For endpoints that vary in bandwidth or for those where no accurate estimation can be made, this property should contain the nominal bandwidth.
NICEndDateTime	datetime	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.
NICStartDateTime	datetime	Null values allowed	Start of the time period that this row was known to be valid. Indicates date that item was first inventoried by SMS.

See Also

Other Resources

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