SCRM 2006 SC_NodeEnclosure_OUTRIGGER_View

2006-09-10

SC_NodeEnclosure_OUTRIGGER_View lists hardware inventory for the enclosures for a managed node.

SC_NodeEnclosure_OUTRIGGER_View

Column	Type	Constraint	Description
NodeEnclosureKey	int	Not Null	Key that uniquely identifies a node enclosure 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.
EnclosureEndTimeKey	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.
EnclosureEndDateKey	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.
EnclosureEndDateLineageKey	int	Null values allowed	Key that identifies lineage of the DTS package that last identified this entry. A current entry has a NULL end date and time and NULL lineage end date. This is a foreign key into SC_LineageDimension_Table.
EnclosureStartTimeKey	int	Not Null	Start of the time period that this row was known valid. Indicates the date that the item was first inventoried by SMS.
EnclosureStartDateKey	smallint	Not Null	Start of the time period that this row was known valid. Indicates the date that the item was first inventoried by SMS.
EnclosureStartDateLineageKey	int	Not Null	Identifies lineage of the DTS package that first identified this entry. This is a foreign key into SC_LineageDimension_Table.
EnclosureChassisType	nvarchar	Null values allowed	Array of chassis types, using the following values: 1 - Other 2 - Unknown 3 - Desktop 4 - Low Profile Desktop 5 - Pizza Box 6 - Mini Tower 7 - Tower 8 - Portable 9 - Laptop 10 - Notebook 11 - Hand Held 12 - Docking Station 13 - All in One 14 - Sub Notebook 15 - Space-Saving 16 - Lunch Box 17 - Main System Chassis 18 - Expansion Chassis 19 - SubChassis 20 - Bus Expansion Chassis 21 - Peripheral Chassis 22 - Storage Chassis 23 - Rack Mount Chassis 24 - Sealed-Case PC
EnclosureManufacturer	nvarchar	Null values allowed	Name of the manufacturer.
EnclosureSerialNumber	nvarchar	Null values allowed	Manufacturer-allocated number used to identify the physical element.
EnclosureSMBIOSAssetTag	nvarchar	Null values allowed	Asset tag number of the system enclosure.

See Also

Other Resources

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