SCRM 2006 SC_File_Dimension_View

SC_File_Dimension_View lists the unique files that are inventoried by the SMS agent for Software Inventory.

SC_File_Dimension_View

Column	Type	Constraint	Description
FileKey	int	Not Null	Key that uniquely identifies each instance of a file in the SC_FileDimension_Table.
FileLineageKey	int	Not Null	Key that references the DTS lineage of the package that first detected that this file entry had been inserted into SMS site database.
FileDescription	nvarchar	Not Null	Optional text description of a file.
FileName	nvarchar	Not Null	File name and extension.
FileSize	bigint	Null values allowed	File size in bytes.
FileVersion	nvarchar	Not Null	Version information about the file.
ProductCompanyName	nvarchar	Not Null	Name of company that produced the product.
ProductVersion	nvarchar	Not Null	Version of the product with which the file is distributed. For example, `3.10` or `5.00.RC2`.
ProductLanguage	int	Null values allowed	Language code of distributed product.
ProductName	nvarchar	Not Null	Name of the product with which the file is distributed.
FileUserProductName	nvarchar	Not Null	Modified product name after user-defined rules have been applied.
FileUserCompanyName	nvarchar	Not Null	Modified company name after user-defined rules have been applied.
FileUserProductVersion	nvarchar	Not Null	Modified product version after user-defined rules have been applied.