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 -------------- .. code-block:: sql select * from programs .. code-block:: sql select name, install_location from programs where install_location not like 'C:\Program Files%';