Attention
Zercurity has been acquired by JumpCloud.
This documentation will no longer be maintained or updated. You can read more about the acquisition, or signup to JumpCloud today.
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%';