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. |
See Also
Other Resources
SCRM 2006 MOM Views
SCRM 2006 Report Customization
SCRM 2006 SMS Views
SCRM 2006 Stored Procedures