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, |
| 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. |