programs

Represents products as they are installed by Windows Installer. A product generally correlates to one installation package on Windows. Some fields may be blank as Windows installation details are left to the discretion of the product author.

Table schema

Name Type Description
name TEXT Commonly used product name.
version TEXT Product version information.
install_location TEXT The installation location directory of the product.
install_source TEXT The installation source of the product.
language TEXT The language of the product.
publisher TEXT Name of the product supplier.
uninstall_string TEXT Path and filename of the uninstaller.
install_date TEXT Date that this product was installed on the system.
identifying_number TEXT Product identification such as a serial number on software, or a die number on a hardware chip.

Query examples

select * from programs
select name, install_location from programs where install_location not like 'C:\Program Files%';