ConsolidatedFileEvidence Template

FlexNet Manager Suite 2020 R1 (On-Premises)

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.

Table 1. Columns included with ConsolidatedFileEvidence templates

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:

ImportedInstalledFileEvidence.ExternalID

ImportedInstalledFileEvidenceUsage.ExternalID

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:

ImportedFileEvidence.ExternalFileID

ImportedFileEvidence.FileName

ImportedInstalledFileEvidence.ExternalFileID

ImportedInstalledFileEvidenceUsage.ExternalFileID

FileVersion

Type: text (max 100 characters). Key. Nullable

The version number of the file used as evidence of software installation.

Destination:

ImportedFileEvidence.ExternalFileID

ImportedFileEvidence.FileVersion

ImportedInstalledFileEvidence.ExternalFileID

ImportedInstalledFileEvidenceUsage.ExternalFileID

ProductVersion

Type: text (max 200 characters). Nullable

The product version number in the file header.

Destination:

ImportedFileEvidence.ProductVersion

ProductName

Type: text (max 200 characters). Nullable

The product name in the file header.

Destination:

ImportedFileEvidence.ProductName

FilePath

Type: text (max 400 characters). Nullable

The path of the file used as evidence of software installation.

Destination:

ImportedFileEvidence.FilePath

Company

Type: text (max 100 characters). Key. Nullable

The company in the file header.

Destination:

ImportedFileEvidence.ExternalFileID

ImportedFileEvidence.Company

ImportedInstalledFileEvidence.ExternalFileID

ImportedInstalledFileEvidenceUsage.ExternalFileID

Description

Type: text (max 200 characters). Key. Nullable

The description in the file header.

Destination:

ImportedFileEvidence.ExternalFileID

ImportedFileEvidence.Description

ImportedInstalledFileEvidence.ExternalFileID

ImportedInstalledFileEvidenceUsage.ExternalFileID

FileSize

Type: integer. Key. Nullable

The size of the file in bytes.

Destination:

ImportedFileEvidence.ExternalFileID

ImportedFileEvidence.FileSize

ImportedInstalledFileEvidence.ExternalFileID

ImportedInstalledFileEvidenceUsage.ExternalFileID

Language

Type: text (max 200 characters). Nullable

The language in the file header.

Destination:

ImportedFileEvidence.Language

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:

  • Local
  • App-V
  • XenApp
  • XenDesktop
  • VMware View
  • Office 365

Destination:

ImportedFileEvidence.ExternalFileID

ImportedFileEvidence.AccessModeID

ImportedInstalledFileEvidence.ExternalFileID

ImportedInstalledFileEvidenceUsage.ExternalFileID

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:

ImportedInstalledFileEvidenceUsage.NumberOfSessions

StartDate

Type: text (max 10 characters). Nullable

The start date of the usage. The date must be specified in the following format: ‘yyyyMMdd’.

Destination:

ImportedInstalledFileEvidenceUsage.StartDate

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:

ImportedInstalledFileEvidenceUsage.LastUsedDate

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:

ImportedInstalledFileEvidenceUsage.ExternalUserID

ImportedUser.ExternalID

ImportedUser.UserName (Element 2 after splitting on '\')

ImportedUser.Domain (Element 1 after splitting on '\')

ImportedUser.SAMAccountName (Element 2 after splitting on '\')

FlexNet Manager Suite (On-Premises)

2020 R1