SCRM 2006 SC_File_Dimension_View

System Center

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.

See Also

Show: