SCRM 2006 SCRS_NodeDisk_Outrigger_View
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 |
| DiskEndDateKey | smallint | Null values allowed | End of the time period that this row was known to be valid. A |
| DiskEndDateLineageKey | int | Null values allowed | Identifies lineage of the DTS package that last identified this entry. A current entry will have a |
| 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:
|
| DiskModel | nvarchar | Not Null | Model number of the disk drive--for example, |
| 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 |
| 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. |