SCRM 2006 SCRS_SoftwareInventory_Fact_View
SCRS_SoftwareInventory_Fact_View describes which files have been installed on each managed node.
SCRS_SoftwareInventory_Fact_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| SoftwareInventoryEndTimeKey | int | Null values allowed | End of the time period that this row was valid. A |
| SoftwareInventoryEndDateKey | smallint | Null values allowed | End of the time period that this row was valid. A |
| SoftwareInventoryEndDateLineageKey | int | Null values allowed | Key that references the DTS lineage of the package that first detected that this file entry no longer existed in the SMS site database. |
| SoftwareInventoryStartTimeKey | int | Not Null | Start of the time period that this row was known valid. Indicates the time that this file was first inventoried by SMS. |
| SoftwareInventoryStartDateKey | smallint | Not Null | Start of the time period that this row was known valid. Indicates the time that this file was first inventoried by SMS. |
| SoftwareInventoryStartDateLineageKey | int | Not Null | Key that references the DTS lineage of the package that first detected that this file entry first appeared in the SMS site database. |
| SoftwareInventoryFileModifiedDate | datetime | Not Null | The last modified date and time stamp of the file in the operating system. |
| FileKey | int | Not Null | Foreign key that references a unique file in the File dimension. |
| 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. |