SCRM 2006 SCRS_NodeDisk_Outrigger_View

Article
09/10/2006

SCRS_NodeDisk_Outrigger_View lists hardware inventory for the disks for a managed node.

SCRS_NodeDisk_Outrigger_View

Column	Type	Constraint	Description
NodeDiskKey	int	Not Null	Uniquely identifies a physical disk associated with the managed node referenced by NodeKey.
NodeKey	int	Not Null	Identifies the managed node associated with this entry. This is a foreign key into SC_ManagedNodeDimension_Table.
DiskEndTimeKey	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.
DiskEndDateKey	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.
DiskEndDateLineageKey	int	Null values allowed	Identifies lineage of the DTS package that last identified this entry. A current entry will have a `NULL` end date/time and `NULL` lineage end date. This is a foreign key into SC_LineageDimension_Table.
DiskStartTimeKey	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.
DiskStartDateKey	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.
DiskStartDateLineageKey	int	Not Null	Identifies lineage of the DTS package that first identified this entry. This is a foreign key into SC_LineageDimension_Table.
DiskInterfaceType	nvarchar	Not Null	Interface type of physical disk drive; for example, "SCSI."
DiskManufacturer	nvarchar	Not Null	Manufacturer model number of the disk drive.
DiskMediaType	nvarchar	Not Null	Type of media used or accessed by this device, using the following values: Removable media. Fixed hard disk. Unknown.
DiskModel	nvarchar	Not Null	Model number of the disk drive--for example, `ST32171W`.
DiskName	nvarchar	Not Null	Label by which the disk is known.
DiskPartitions	int	Null values allowed	Number of partitions on this physical disk drive that are recognized by the operating system.
DiskSize	bigint	Null values allowed	Size of the disk drive in bytes, calculated by multiplying the total number of cylinders, tracks in each cylinder, sectors in each track, and bytes in each sector.
DiskEndDateTime	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.
DiskStartDateTime	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