SCRM 2006 SC_NodeUSBController_OUTRIGGER_View
SC_NodeUSBController_OUTRIGGER_View lists hardware inventory for the USB devices on a managed node.
SC_NodeUSBController_OUTRIGGER_View List
| Column | Type | Constraint | Description |
|---|---|---|---|
| NodeUSBControllerKey | int | Not Null | Key that uniquely identifies a USB controller 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. |
| USBControllerEndTimeKey | int | Null values allowed | End of the time period that this row was known to be valid. A |
| USBControllerEndDateKey | smallint | Null values allowed | End of the time period that this row was known to be valid. A |
| USBControllerEndDateLineageKey | int | Null values allowed | Key that identifies lineage of the DTS package that last identified this entry. A current entry will have a |
| USBControllerStartTimeKey | 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. |
| USBControllerStartDateKey | 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. |
| USBControllerStartDateLineageKey | 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. |
| USBControllerManufacturer | nvarchar | Null values allowed | Manufacturer of the controller. |
| USBControllerName | nvarchar | Null values allowed | Name of the controller. |