SCRM 2006 SCRS_LogicalDiskFreeSpace_Fact_View
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 |
LogicalDiskFreeSpaceEndDateKey |
smallint |
Null values allowed |
End of the time period that this row was valid. A |
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