App-V Release 4.6 Data Transfers

IT Asset Management (Cloud)

This table lists the data extracted from App-V release 4.6, and where it is stored the compliance database in IT Asset Management. Imported data is stored in temporary staging tables for data manipulation, and then moved into their final destination tables as noted below. These columns in the compliance database are available for use in custom reports, and the like.

App-V (Table)/Column	FNMS (Table)/Column	Notes
(REPORTING_CLIENT_INFORMATION) host_name	(ComplianceComputer) ComputerName	If the computer name already exists in the ComplianceComputer table, this device is identified as the consuming device. If it does not already exist, the device is added to the ComplianceComputer table with a ComplianceComputerTypeID of 4, which (through the ComplianceComputerType table) indicates a remote device from which inventory cannot be collected. All such created records display their connection name (as the Inventory Agent), are marked as incomplete records, and are given a fictitious serial number of 1.
(REPORTING_CLIENT_INFORMATION) host_name	(ComplianceComputer) ComplianceDomainID	The domain name is extracted from the host record on the App-V server. If the domain does not already exist in the compliance database, it is added to the ComplianceDomain table, and as required the ComplianceDomainID may be updated in the ComplianceComputer table.
(APPLICATION_USAGE) username	(ComplianceComputer) ComplianceUserID	The last logged on user for this computer.
(VW_APPLICATIONS) app_name	(InstallerEvidence) DisplayName	The name of the App-V package (which may bear no resemblance to the application inside) is used to identify the evidence record. Note: It is possible for an App-V package to contain more than one application. This makes it impossible to link the App-V evidence to a single application record. Best practice is to make each package contain exactly one licensable application.
(VW_APPLICATIONS) version	(InstallerEvidence) Version	The version of the App-V package. Again, this bears no necessary relationship to the version of the application inside the package, and is at the whim of the person preparing the package (for example, it may represent the number of times the application package was modified).
String literal App-V	(InstallerEvidence) Publisher	All App-V evidence is given the publisher name of App-V.