SCRM 2006 SC_NodeSound_OUTRIGGER_View
SC_NodeSound_OUTRIGGER_View lists hardware inventory for the sound cards on a managed node.
SC_NodeSound_OUTRIGGER_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| NodeSoundKey | int | Not Null | Key that uniquely identifies a sound device 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. |
| SoundEndTimeKey | int | Null values allowed | End of the time period that this row was known valid. A |
| SoundEndDateKey | 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. |
| SoundEndDateLineageKey | int | Null values allowed | Key that identifies lineage of the DTS package that last identified this entry. A current entry has a |
| SoundStartTimeKey | 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. |
| SoundStartDateKey | 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. |
| SoundStartDateLineageKey | 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. |
| SoundManufacturer | nvarchar | Null values allowed | Manufacturer of the sound device. For example, Creative Labs. |
| SoundProductName | nvarchar | Null values allowed | Product name of the sound device. For example, |