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.

Platform support

Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: programs

  • Windows

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%';