ConsolidatedInstallerEvidence Template

FlexNet Manager Suite 2020 R1 (On-Premises)

ConsolidatedInstallerEvidence provides a simpler interface to specify installed applications and their usage on computers. It combines the computer, installer evidence and usage details into a single row.

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:

ImportedInstalledInstallerEvidence.ExternalComputerID

ImportedInstalledInstallerEvidenceUsage.ExternalID

ImportedInstance.ExternalComputerID

InstanceName

Type: big integer. Key. Nullable

If this installer evidence is an Oracle database, then this field specifies the name of the database instance. If there are multiple instances, create a row for each instance in this spreadsheet.

Destination:

ImportedInstalledInstallerEvidence.ExternalInstanceID

ImportedInstalledInstallerEvidenceUsage.ExternalInstanceID

ImportedInstance.InstanceID

ImportedInstance.ParentInstanceID

ImportedInstance.InstanceName

DisplayName

Type: text (max 256 characters). Key

The display name of the software as reported by the installer evidence.

Destination:

ImportedInstallerEvidence.ExternalInstallerID

ImportedInstallerEvidence.DisplayName

ImportedInstalledInstallerEvidence.ExternalInstaller EvidenceID

ImportedInstalledInstallerEvidenceUsage.ExternalInstallerID

Version

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

The version of the software as reported by the installer evidence.

Destination:

ImportedInstallerEvidence.ExternalInstallerID

ImportedInstallerEvidence.Version

ImportedInstalledInstallerEvidence.ExternalInstaller EvidenceID

ImportedInstalledInstallerEvidenceUsage.ExternalInstallerID

Publisher

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

The publisher of the software as reported by the installer evidence.

Destination:

ImportedInstallerEvidence.ExternalInstallerID

ImportedInstallerEvidence.Publisher

ImportedInstalledInstallerEvidence.ExternalInstaller EvidenceID

ImportedInstalledInstallerEvidenceUsage.ExternalInstallerID

Evidence

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

Identifier for the type of installer evidence.

Destination:

ImportedInstallerEvidence.ExternalInstallerID

ImportedInstallerEvidence.Evidence

ImportedInstalledInstallerEvidence.ExternalInstaller EvidenceID

ImportedInstalledInstallerEvidenceUsage.ExternalInstallerID

ProductCode

Type: text (max 55 characters). Nullable

The product code of the evidence. This is usually the MSI product code.

Destination:

ImportedInstallerEvidence.ProductCode

AccessMode

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

The access mode of the installer 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:

ImportedInstallerEvidence.ExternalInstallerID

ImportedInstallerEvidence.AccessModeID

ImportedInstalledInstallerEvidence.ExternalInstaller EvidenceID

ImportedInstalledInstallerEvidenceUsage.ExternalInstallerID

InstallDate

Type: text (max 10 characters). Nullable

The install date of the installer evidence. The date must be specified in the following format: ‘yyyyMMdd’.

Destination:

ImportedInstalledInstallerEvidence.InstallDate

DiscoveryDate

Type: text (max 10 characters). Nullable

The date that the installer evidence was first seen. The date must be specified in the following format: ‘yyyyMMdd’.

Destination:

ImportedInstalledInstallerEvidence.DiscoveryDate

NumberOfSessions

Type: big integer. Nullable

The number of sessions that the installer 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:

ImportedInstalledInstallerEvidenceUsage.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:

ImportedInstalledInstallerEvidenceUsage.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:

ImportedInstalledInstallerEvidenceUsage.LastUsedDate

UserID

Type: big integer. Key. Nullable

The DOMAIN/SAMAccountName for the user that the installer 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:

ImportedInstalledInstallerEvidenceUsage.ExternalUserID

ImportedUser.ExternalID

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

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

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