SCRM 2006 SCRS_LogicalDiskFreeSpace_Fact_View

Article
09/10/2006

SCRS_LogicalDiskFreeSpace_Fact_View lists the free space and total size of each logical disk on each managed node.

SCRS_LogicalDiskFreeSpace_Fact_View

Column	Type	Constraint	Description
LogicalDiskKey	int	Not Null	Foreign key that references a unique logical disk in the Logical Disk dimension.
LogicalDiskFreeSpaceEndTimeKey	int	Null values allowed	End of the time period that this row was valid. A `NULL` value indicates this row contains the current information. A non-`NULL` value indicates the last time that this row was known to be valid.
LogicalDiskFreeSpaceEndDateKey	smallint	Null values allowed	End of the time period that this row was valid. A `NULL` value indicates this row contains the current information. A non-`NULL` value indicates the last date that this row was known to be valid.
LogicalDiskFreeSpaceEndDateLineageKey	int	Null values allowed	Key that references the DTS lineage of the package that first detected that this logical disk free space entry was no longer the most current measurement existing in the SMS site database.
LogicalDiskFreeSpaceStartTimeKey	int	Not Null	Start of the time period that this row was known to be valid. Indicates time that this logical disk free space entry was first inventoried by SMS.
LogicalDiskFreeSpaceStartDateKey	smallint	Not Null	Start of the time period that this row was known to be valid. Indicates time that this logical disk free space entry was first inventoried by SMS.
LogicalDiskFreeSpaceStartDateLineageKey	int	Not Null	Key that references the DTS lineage of the package that first detected that this logical disk free space entry had been inserted into the SMS site database.
LogicalDiskFreeSpace	bigint	Not Null	Space available on the logical disk.
LogicalDiskSize	bigint	Not Null	Total size of the disk drive.
LocationKey	int	Not Null	Foreign key that references a unique node location in the Node Location dimension.
NodeKey	int	Not Null	Foreign key that references a unique managed node in the Managed Node dimension.
UserKey	int	Not Null	Foreign key that references a unique user in the User dimension.
SMSSiteKey	int	Not Null	Foreign key that references a unique SMS site in the SMS Site dimension.

See Also

Other Resources

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