SCRM 2006 SCRS_NodeCDROM_OUTRIGGER_View

2006-09-10

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 `NULL` value indicates this row contains the current information.
CDROMEndDateKey	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.
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 `NULL` end date/time and `NULL` lineage end date. This is a foreign key into SC_LineageDimension_Table.
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, `d:\.`
CDROMManufacturer	nvarchar	Not Null	Manufacturer of the Windows CD-ROM drive—for example, `PLEXTOR`.
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 `NULL` value indicates this row contains the current information.
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.

See Also

Other Resources

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