Analysis to query Installed application on Windows XP and Winddows 7

(imported topic written by rmustapha91)

I copied the analysis below and modified it to my taste but the result is not consistent. Some machine responded ok with data of installed applications but some machines shows “Error” message. When I highlight the error message, all I got is “…”. Can someone help me out please? Thanks in advance

(concatenation “; " of (if it = “” then nothing else it) of unique values of ((if (exists value “DisplayName” of it AND exists value “DisplayName” of it as string) then (value “DisplayName” of it as string) else (”")) & (if (exists value “DisplayVersion” of it AND exists value “DisplayVersion” of it as string) then (" V: " & value “DisplayVersion” of it as string) else (""))) of keys whose (((not exists value “SystemComponent” of it) OR (exists value “SystemComponent” of it AND name of it starts with “{” AND name of it contains “}” AND (exists match (regex “(9|A|B|C)(0|1)1(2|4)\d\d\d\d-(0011|0012|0013|0014|0017|002E|002F|0030|0031|0033|0035|003A|003B|0044|0051|0052|0053|0057|00BA |00CA|10D7|110D)-(0000|0409)-(0|1)000-(0|1)000000FF1CE$”) of preceding text of first “}” of following text of first “{” of name of it))) AND (if (exists value “DisplayName” of it AND exists value “DisplayName” of it as string) then ((it does not contain “Hotfix” AND it does not contain “Security Update for” AND it does not contain “Update for” AND it does not contain “Security Update for Windows” AND it does not contain “Update for Windows” AND it does not contain “Security Update for Microsoft” AND (length of it > 0) AND (number of substrings " " of it < length of it)) of (value “DisplayName” of it as string)) else true)) of keys “HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall” of (if x64 of operating system then (x32 registry; x64 registry) else registry))

(imported comment written by SystemAdmin)

Surprised no one else replied.

As far as I can remember (it’s been a while and I’m not currently managing TEM anywhere), it’s because you’re returning too much information to be stored and the ellipses (…) refer to the fact that the GUI is essentially giving up trying to display the data in the current form.

-Jim