SCRM 2006 SCRS_LogicalDisk_Dimension_View

SCRS_LogicalDisk_Dimension_View lists details of each logical disk on a managed node.

SCRS_LogicalDisk_Dimension_View

Column	Type	Constraint	Description
LogicalDiskKey	int	Not Null	Key that uniquely identifies a given logical disk.
LogicalDiskLineageKey	int	Not Null	Key that references the DTS lineage of the package that first detected that this logical disk entry had been inserted into the SMS site database.
LogicalDiskDriveLetter	nvarchar	Not Null	Logical disk drive letter.
LogicalDiskCompressed	tinyint	Null values allowed	Logical disk compression. `TRUE` if the logical volume exists as a single compressed entity, such as a DoubleSpace volume, and `FALSE` if file-based compression is supported (such as on NTFS).
LogicalDiskDescription	nvarchar	Not Null	Textual description of the logical disk.
LogicalDiskFileSystem	nvarchar	Null values allowed	File system on the logical disk—for example, `NTFS`.
LogicalDiskSystemDriveFlag	tinyint	Not Null	Flag that indicates whether this is the system drive.