SCRM 2006 SCRS_NodeCDROM_OUTRIGGER_View
SCRS_NodeCDROM_OUTRIGGER_View lists hardware inventory for the CD-ROM drives for a managed node.
SCRS_NodeCDROM_OUTRIGGER_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| NodeCDROMKey | int | Not Null | Key that uniquely identifies a CD-ROM 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. |
| CDROMEndTimeKey | int | Null values allowed | End of the time period that this row was known to be valid. A |
| CDROMEndDateKey | smallint | Null values allowed | End of the time period that this row was known to be valid. A |
| CDROMEndDateLineageKey | int | Null values allowed | Key that references the lineage of the DTS package that last identified this entry in the SMS site database. A current entry will have a |
| CDROMStartTimeKey | int | Not Null | Start of the time period that this row was known to be valid. Indicates time that item was first inventoried by SMS. |
| CDROMStartDateKey | 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. |
| CDROMStartDateLineageKey | int | Not Null | Key that references the DTS lineage of the package that first detected that this CD-ROM entry had been inserted into the SMS site database. |
| CDROMDrive | nvarchar | Not Null | Drive letter of the CD-ROM drive—for example, |
| CDROMManufacturer | nvarchar | Not Null | Manufacturer of the Windows CD-ROM drive—for example, |
| CDROMName | nvarchar | Not Null | Name of the Windows CD-ROM drive. |
| CDROMEndDateTime | datetime | Null values allowed | End of the time period that this row was known to be valid. A |
| CDROMStartDateTime | 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. |