SCRM 2006 SCRS_SoftwareInventory_Fact_View

2006-09-10

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 `NULL` value indicates this row contains the current information. A non-`NULL` value indicates the last time that this row was known valid.
SoftwareInventoryEndDateKey	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 valid.
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