Hi All,
can any one please help me in getting a list of installed applications along with their respective installed path?
Currently using below query.
q: unique values of ( ( (value “DisplayName” of it as string & (if (exists value “DisplayVersion” of it) then ("||" & value “DisplayVersion” of it as string) else ("||")) & (if (exists value “Publisher” of it) then ("||" & value “Publisher” of it as string) else ("||")) & (if (exists value “InstallDate” of it) then ("||" & value “InstallDate” of it as string) else ("||")) & (if (exists value “InstallLocation” of it) then ("||" & value “InstallLocation” of it as string) else ("||"))) of keys whose ((not exists value “SystemComponent” of it OR value “SystemComponent” of it as string != “1”) AND (not exists value “WindowsInstaller” of it OR value “WindowsInstaller” of it as string != “1”) AND exists value “UninstallString” of it AND not exists value “ParentKeyName” of it AND exists value “DisplayName” of it) of key “HKLM\Software\Microsoft\Windows\CurrentVersion\Uninstall” of native registry) ; (if x64 of operating system then((value “DisplayName” of it as string & (if (exists value “DisplayVersion” of it) then ("||" & value “DisplayVersion” of it as string) else ("||")) & (if (exists value “Publisher” of it) then ("||" & value “Publisher” of it as string) else ("||")) & (if (exists value “InstallDate” of it) then ("||" & value “InstallDate” of it as string) else ("||")) & (if (exists value “InstallLocation” of it) then ("||" & value “InstallLocation” of it as string) else ("||"))) of keys whose ((not exists value “SystemComponent” of it OR value “SystemComponent” of it as string != “1”) AND (not exists value “WindowsInstaller” of it OR value “WindowsInstaller” of it as string != “1”) AND exists value “UninstallString” of it AND not exists value “ParentKeyName” of it AND exists value “DisplayName” of it) of key “HKLM\Software\Microsoft\Windows\CurrentVersion\Uninstall” of registry) else nothing) ; ((value “DisplayName” of it as string & (if (exists value “DisplayVersion” of it) then ("||" & value “DisplayVersion” of it as string) else ("||")) & (if (exists value “Publisher” of it) then ("||" & value “Publisher” of it as string) else ("||")) & (if (exists value “InstallDate” of it) then ("||" & value “InstallDate” of it as string) else ("||")) & (if (exists value “InstallLocation” of it) then ("||" & value “InstallLocation” of it as string) else ("||"))) of keys whose ((not exists value “SystemComponent” of it OR value “SystemComponent” of it as string != “1”) AND (not exists value “WindowsInstaller” of it OR value “WindowsInstaller” of it as string != “1”) AND exists value “UninstallString” of it AND not exists value “ParentKeyName” of it AND exists value “DisplayName” of it) of keys “Software\Microsoft\Windows\CurrentVersion\Uninstall” of keys whose (exists key “Software\Microsoft\Windows\CurrentVersion\Uninstall” of it) of key “HKU” of registry) ; ((value “ProductName” of item 0 of it as string & ((if (exists value “DisplayVersion” of it) then ("||" & value “DisplayVersion” of it as string) else ("||")) & (if (exists value “Publisher” of it) then ("||" & value “Publisher” of it as string) else ("||")) & (if (exists value “InstallDate” of it) then ("||" & value “InstallDate” of it as string) else ("||")) & (if (exists value “InstallLocation” of it) then ("||" & value “InstallLocation” of it as string) else ("||"))) of key “InstallProperties” of item 1 of it) of it whose ((not exists value “SystemComponent” of it OR value “SystemComponent” of it as string != “1”) of key “InstallProperties” of item 1 of it AND exists value “ProductName” of item 0 of it) of (keys of item 0 of it, keys of item 1 of it) whose (name of item 0 of it = name of item 1 of it) of (key “Software\Microsoft\Installer\Products” of item 0 of it, key “Products” of item 1 of it) of (keys of key “HKU” of it, keys of key “HKLM\Software\Microsoft\Windows\CurrentVersion\Installer\UserData” of it) whose ((exists key “Software\Microsoft\Installer\Products” of item 0 of it and exists key “Products” of item 1 of it)) of native registry) ; (elements of (set of ((value “DisplayName” of it as string & (if (exists value “DisplayVersion” of it) then ("||" & value “DisplayVersion” of it as string) else ("||")) & (if (exists value “Publisher” of it) then ("||" & value “Publisher” of it as string) else ("||")) & (if (exists value “InstallDate” of it) then ("||" & value “InstallDate” of it as string) else ("||")) & (if (exists value “InstallLocation” of it) then ("||" & value “InstallLocation” of it as string) else ("||"))) of it whose ((not exists value “SystemComponent” of it OR value “SystemComponent” of it as string != “1”) AND (exists value “WindowsInstaller” of it AND value “WindowsInstaller” of it as string = “1”) AND exists value “DisplayName” of it) of keys “InstallProperties” of items 1 of (keys of key “HKLM\Software\Classes\Installer\Products” of it, keys of key “HKLM\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products” of it) whose (name of item 0 of it = name of item 1 of it) of native registry) - set of ((value “DisplayName” of it as string & (if (exists value “DisplayVersion” of it) then ("||" & value “DisplayVersion” of it as string) else ("||")) & (if (exists value “Publisher” of it) then ("||" & value “Publisher” of it as string) else ("||")) & (if (exists value “InstallDate” of it) then ("||" & value “InstallDate” of it as string) else ("||")) & (if (exists value “InstallLocation” of it) then ("||" & value “InstallLocation” of it as string) else ("||"))) of keys whose ((exists value “SystemComponent” of it AND value “SystemComponent” of it as string = “1”) AND (exists value “WindowsInstaller” of it AND value “WindowsInstaller” of it as string = “1”) AND exists value “UninstallString” of it AND not exists value “ParentKeyName” of it AND exists value “DisplayName” of it) of key “HKLM\Software\Microsoft\Windows\CurrentVersion\Uninstall” of native registry ; (if (x64 of operating system) then((value “DisplayName” of it as string & (if (exists value “DisplayVersion” of it) then ("||" & value “DisplayVersion” of it as string) else ("||")) & (if (exists value “Publisher” of it) then ("||" & value “Publisher” of it as string) else ("||")) & (if (exists value “InstallDate” of it) then ("||" & value “InstallDate” of it as string) else ("||")) & (if (exists value “InstallLocation” of it) then ("||" & value “InstallLocation” of it as string) else ("||"))) of keys whose ((exists value “SystemComponent” of it AND value “SystemComponent” of it as string = “1”) AND (exists value “WindowsInstaller” of it AND value “WindowsInstaller” of it as string = “1”) AND exists value “UninstallString” of it AND not exists value “ParentKeyName” of it AND exists value “DisplayName” of it) of key “HKLM\Software\Microsoft\Windows\CurrentVersion\Uninstall” of registry) else nothing)))) ; ( (value “DisplayName” of it as string & (if (exists value “DisplayVersion” of it) then ("||" & value “DisplayVersion” of it as string) else ("||")) & (if (exists value “Publisher” of it) then ("||" & value “Publisher” of it as string) else ("||")) & (if (exists value “InstallDate” of it) then ("||" & value “InstallDate” of it as string) else ("||")) & (if (exists value “InstallLocation” of it) then ("||" & value “InstallLocation” of it as string) else ("||"))) of items 1 of (keys of key “HKLM\Software\Classes\Installer\Products” of it, keys of key “HKLM\Software\Microsoft\Windows\CurrentVersion\Uninstall” of it) whose ((value “ProductName” of item 0 of it = value “DisplayName” of item 1 of it) AND ((not exists value “SystemComponent” of it OR value “SystemComponent” of it as string != “1”) AND (exists value “WindowsInstaller” of it AND value “WindowsInstaller” of it as string = “1”) AND exists value “UninstallString” of it AND not exists value “ParentKeyName” of it AND exists value “DisplayName” of it) of item 1 of it) of native registry ; (value “DisplayName” of it as string & (if (exists value “DisplayVersion” of it) then ("||" & value “DisplayVersion” of it as string) else ("||")) & (if (exists value “Publisher” of it) then ("||" & value “Publisher” of it as string) else ("||")) & (if (exists value “InstallDate” of it) then ("||" & value “InstallDate” of it as string) else ("||")) & (if (exists value “InstallLocation” of it) then ("||" & value “InstallLocation” of it as string) else ("||"))) of items 1 of (keys of key “HKLM\Software\Classes\Installer\Products” of native registry, keys of key “HKLM\Software\Microsoft\Windows\CurrentVersion\Uninstall” of registry) whose ((value “ProductName” of item 0 of it = value “DisplayName” of item 1 of it) AND ((not exists value “SystemComponent” of it OR value “SystemComponent” of it as string != “1”) AND (exists value “WindowsInstaller” of it AND value “WindowsInstaller” of it as string = “1”) AND exists value “UninstallString” of it AND not exists value “ParentKeyName” of it AND exists value “DisplayName” of it) of item 1 of it) ; (value “DisplayName” of it as string & (if (exists value “DisplayVersion” of it) then ("||" & value “DisplayVersion” of it as string) else ("||")) & (if (exists value “Publisher” of it) then ("||" & value “Publisher” of it as string) else ("||")) & (if (exists value “InstallDate” of it) then ("||" & value “InstallDate” of it as string) else ("||")) & (if (exists value “InstallLocation” of it) then ("||" & value “InstallLocation” of it as string) else ("||"))) of items 1 of (keys of key “HKLM\Software\Classes\Installer\Products” of it, keys “Software\Microsoft\Windows\CurrentVersion\Uninstall” of keys whose (exists key “Software\Microsoft\Windows\CurrentVersion\Uninstall” of it) of key “HKU” of it) whose ((value “ProductName” of item 0 of it = value “DisplayName” of item 1 of it) AND ((not exists value “SystemComponent” of it OR value “SystemComponent” of it as string != “1”) AND (exists value “WindowsInstaller” of it AND value “WindowsInstaller” of it as string = “1”) AND exists value “UninstallString” of it AND not exists value “ParentKeyName” of it AND exists value “DisplayName” of it) of item 1 of it) of native registry ) )