pvl_win_installer_properties
Purpose
The "pvl_win_installer_properties" is an SQL custom table that is used in conjunction with the CWM - Automate - Script - Windows Installer Properties [DV] script and the "Windows Installer Properties [Script]" dataview. The purpose of this table is to store the gathered information about the properties of the Windows Installer applications installed on a machine. It stores the data fetched by the CWM - Automate - Script - Windows Installer Properties [DV] script.
Dependencies
Tables
pvl_win_installer_properties
| Column | Type | Explanation |
|---|---|---|
| computerid | int(16) | Computer ID |
| Name | varchar(128) | Display Name of the Application |
| Version | varchar(32) | Display Version of the Application |
| Publisher | varchar(128) | Application's Publisher |
| InstallDate | varchar(10) | Install Date of the application in numerics |
| URLInfoAbout | varchar(256) | URL of the information related to the application |
| URLUpdateInfo | varchar(256) | URL of the information related to the application's updates |
| InstallSource | varchar(512) | Path to the installer on the local machine |
| InstallLocation | varchar(512) | Path to the installed location of the application on the local machine |
| ScriptRunTime | datetime | Data Collection Time |
| SerialNumber | int | Auto-incremental column to be used as primary key |