This table lists all applications installed on each computer. This can be very useful if you want to be sure that you own enough licenses of your programs.
|
Field name |
Data type |
Description |
|
id_snapshot |
number |
Identifier of the network snapshot. |
|
server_name |
string |
Netbios name of the server without the two preceding backslash characters. |
|
product |
string |
Name of the software (as shown in the Add/Remove programs control panel applet). |
|
uninstaller |
string |
Path of the program removing the software from the computer. |
|
InternalName |
string |
Key in the registry |
|
InstallSource |
string |
Location of the setup file (Windows installer setup only) |
|
DisplayVersion |
string |
Textual version number |
|
Publisher |
string |
Publisher |
|
InstallDate |
time |
Installation date (Windows installer setup only) |
|
LastModificationDate |
time |
Installation date (if not upgraded) or last upgrade date. |
|
Version |
number |
Version number (Windows installer setup only) |
|
VersionMajor |
number |
Major version number (Windows installer setup only) |
|
VersionMinor |
number |
Minor version number (Windows installer setup only) |
|
EstimatedSize |
number |
Size of the application (in KB) (Windows installer setup only) |
|
TranslatedProduct |
string |
Currently not used |
|
Edition |
string |
Currently not used |
|
SPNumber |
number |
Currently not used |
|
WindowsInstaller |
number |
Currently not used |
|
UpgradeCode |
string |
Currently not used |
To know how many licenses of WinZip are needed in the domain 'MYDOMAIN', use the following SQL query:
SELECT COUNT(*)
FROM software, server_name
WHERE
software.server_name = servers.server_name AND
software.product = 'WinZip' AND
servers.server_name = 'MYDOMAIN'