ConsolidatedFileEvidence Template
ConsolidatedFileEvidence provides a simpler interface to specify files and their usage on computers. It combines the computer, file evidence and usage details into a single row.
Column |
Details |
---|---|
ComputerID
|
Type: big integer. Key The identifier used in the source connection for the computer. It must match the ComputerID from the Computer spreadsheet or the row will be ignored. Destination:
|
FileName
|
Type: text (max 256 characters). Key The name of the file used as evidence of software installation. For unix operating systems include the full path in the file name, including the opening ‘/’. For Windows operating systems the file path is specified in the FilePath column and this column must only contain the file name. Destination:
|
FileVersion
|
Type: text (max 100 characters). Key. Nullable The version number of the file used as evidence of software installation. Destination:
|
ProductVersion
|
Type: text (max 200 characters). Nullable The product version number in the file header. Destination:
|
ProductName
|
Type: text (max 200 characters). Nullable The product name in the file header. Destination:
|
FilePath
|
Type: text (max 400 characters). Nullable The path of the file used as evidence of software installation. Destination:
|
Company
|
Type: text (max 100 characters). Key. Nullable The company in the file header. Destination:
|
Description
|
Type: text (max 200 characters). Key. Nullable The description in the file header. Destination:
|
FileSize
|
Type: integer. Key. Nullable The size of the file in bytes. Destination:
|
Language
|
Type: text (max 200 characters). Nullable The language in the file header. Destination:
|
AccessMode
|
Type: text (max 128 characters). Key. Nullable The access mode of the file evidence. Leave this blank unless this row is a virtualized application. In that case choose one of the values below that matches your application or desktop virtualization infrastructure. Possible values:
Destination:
|
NumberOfSessions
|
Type: big integer. Nullable The number of sessions that the file evidence was in use by the user specified in the UserID column during the usage tracking period. If multiple users used the same application on the computer, create one row for each user with usage. Destination:
|
StartDate
|
Type: text (max 10 characters). Nullable The start date of the usage. The date must be specified in the following format: ‘yyyyMMdd’. Destination:
|
LastUsedDate
|
Type: text (max 10 characters). Nullable The last used date of the usage. The date must be specified in the following format: ‘yyyyMMdd’. Destination:
|
UserID
|
Type: big integer. Key. Nullable The DOMAIN/SAMAccountName for the user that the file evidence was used by. If this software was used by multiple users, create one row for each user of the software on the computer. Destination:
|
FlexNet Manager Suite (On-Premises)
2020 R1