IBM: BES Inventory Analysis Not Working Properly

Usage and Config Platform
1

I’ve noticed that the ‘Microsoft Office Suite Information (Windows)’ analysis is not retrieving the full name of the installed version of office. For almost all of my machines, I’m getting an error. This is a built-in analysis from IBM and may need to be looked at.

2

Can you provide the exact name of the property that isn’t working and the relevance?

You may need to file a PMR/RFE to ultimately get this addressed: How to ask for IBM product help: PMRs, RFEs, and more

Related: https://bigfix.me/analysis/details/2994711

3

The name of the property is ‘Full Name of Installed Microsoft Office Suite(s)’. The relevance for this contains quite a bit, so I’ll have to break it up in to two parts for a post…but here it is:

Part 1 -

unique values of (((value "DisplayName" of it as string) of (keys whose (((it contains "Office8.0") of (name of it)) AND exists value "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry)); (if ((exists key whose ((((length of it = 38) AND (it contains "-78E1-11D2-B60F-006097C998E7}" AND ((it = "00" OR it = "01" OR it = "02" OR it = "03") of last 2 of (first 5 of it)))) of (name of it)) AND exists value "DisplayVersion" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry)) AND ((((value "DisplayVersion" of it as string >= "9.0.0.3822") AND (value "DisplayVersion" of it as string < "9.0.0.4527")) of (key whose ((((length of it = 38) AND (it contains "-78E1-11D2-B60F-006097C998E7}" AND ((it = "00" OR it = "01" OR it = "02" OR it = "03") of last 2 of (first 5 of it)))) of (name of it)) AND exists value "DisplayVersion" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry))) then ((value "DisplayName" of it as string & " (Service Pack 1)") of (key whose ((((length of it = 38) AND (it contains "-78E1-11D2-B60F-006097C998E7}" AND ((it = "00" OR it = "01" OR it = "02" OR it = "03") of last 2 of (first 5 of it)))) of (name of it)) AND exists value "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry)) else (nothing)); (if ((exists key whose ((((length of it = 38) AND (it contains "-78E1-11D2-B60F-006097C998E7}" AND ((it = "00" OR it = "01" OR it = "02" OR it = "03") of last 2 of (first 5 of it)))) of (name of it)) AND exists value "DisplayVersion" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry)) AND ((((value "DisplayVersion" of it as string >= "9.0.0.4527") AND (value "DisplayVersion" of it as string < "9.0.0.6926")) of (key whose ((((length of it = 38) AND (it contains "-78E1-11D2-B60F-006097C998E7}" AND ((it = "00" OR it = "01" OR it = "02" OR it = "03") of last 2 of (first 5 of it)))) of (name of it)) AND exists value "DisplayVersion" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry))) then ((value "DisplayName" of it as string & " (Service Pack 2)") of (key whose ((((length of it = 38) AND (it contains "-78E1-11D2-B60F-006097C998E7}" AND ((it = "00" OR it = "01" OR it = "02" OR it = "03") of last 2 of (first 5 of it)))) of (name of it)) AND exists value "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry)) else (nothing)); (if ((exists key whose ((((length of it = 38) AND (it contains "-78E1-11D2-B60F-006097C998E7}" AND ((it = "00" OR it = "01" OR it = "02" OR it = "03") of last 2 of (first 5 of it)))) of (name of it)) AND exists value "DisplayVersion" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry)) AND ((((value "DisplayVersion" of it as string >= "9.0.0.6926") AND ("0"&value "DisplayVersion" of it as string < "10")) of (key whose ((((length of it = 38) AND (it contains "-78E1-11D2-B60F-006097C998E7}" AND ((it = "00" OR it = "01" OR it = "02" OR it = "03") of last 2 of (first 5 of it)))) of (name of it)) AND exists value "DisplayVersion" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry))) then ((value "DisplayName" of it as string & " (Service Pack 3)") of (key whose ((((length of it = 38) AND (it contains "-78E1-11D2-B60F-006097C998E7}" AND ((it = "00" OR it = "01" OR it = "02" OR it = "03") of last 2 of (first 5 of it)))) of (name of it)) AND exists value "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry)) else (nothing)) ;(if ((exists key whose ((((length of it = 38) AND (it contains "-78E1-11D2-B60F-006097C998E7}" AND ((it = "00" OR it = "01" OR it = "02" OR it = "03") of last 2 of (first 5 of it)))) of (name of it)) AND exists value "DisplayVersion" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry)) AND ((((value "DisplayVersion" of it as string >= "9") AND (value "DisplayVersion" of it as string < "9.0.0.3822")) of (key whose ((((length of it = 38) AND (it contains "-78E1-11D2-B60F-006097C998E7}" AND ((it = "00" OR it = "01" OR it = "02" OR it = "03") of last 2 of (first 5 of it)))) of (name of it)) AND exists value "DisplayVersion" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry))) then ((value "DisplayName" of it as string & " (No Service Pack)") of (key whose ((((length of it = 38) AND (it contains "-78E1-11D2-B60F-006097C998E7}" AND ((it = "00" OR it = "01" OR it = "02" OR it = "03") of last 2 of (first 5 of it)))) of (name of it)) AND exists value "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry)) else (nothing)) ;(if (exists key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0050048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "28" OR it = "29" OR it = "2A" OR it = "33" OR it = "34") of last 2 of (first 5 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) AND (exists key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0050048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "28" OR it = "29" OR it = "2A" OR it = "33" OR it = "34") of last 2 of (first 5 of it)))) of (name of it)) AND (exists values "DisplayVersion" of it) AND ((value "DisplayVersion" of it as string < "10.0.3506.0") AND (value "DisplayVersion" of it as string >= "10"))) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) then (((value "DisplayName" of it as string) of (key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0050048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "28" OR it = "29" OR it = "2A" OR it = "33" OR it = "34") of last 2 of (first 5 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it)) & (" (No Service Pack)") & (" (" & concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of it as string & "\Microsoft Shared\Office10"))) as string) & ")")) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry);
4

Part 2 -

(if (exists key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0050048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "28" OR it = "29" OR it = "2A" OR it = "33" OR it = "34") of last 2 of (first 5 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) AND (exists key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0050048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "28" OR it = "29" OR it = "2A" OR it = "33" OR it = "34") of last 2 of (first 5 of it)))) of (name of it)) AND (exists values "DisplayVersion" of it) AND ((value "DisplayVersion" of it as string < "10.0.4302.0") AND (value "DisplayVersion" of it as string >= "10.0.3506.0"))) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) then (((value "DisplayName" of it as string) of (key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0050048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "28" OR it = "29" OR it = "2A" OR it = "33" OR it = "34") of last 2 of (first 5 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it)) & (" (Service Pack 1)") & (" (" & concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of it as string & "\Microsoft Shared\Office10"))) as string) & ")")) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry); (if (exists key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0050048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "28" OR it = "29" OR it = "2A" OR it = "33" OR it = "34") of last 2 of (first 5 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) AND (exists key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0050048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "28" OR it = "29" OR it = "2A" OR it = "33" OR it = "34") of last 2 of (first 5 of it)))) of (name of it)) AND (exists values "DisplayVersion" of it) AND ((value "DisplayVersion" of it as string < "10.0.6501.0") AND (value "DisplayVersion" of it as string >= "10.0.4302.0"))) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) then (((value "DisplayName" of it as string) of (key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0050048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "28" OR it = "29" OR it = "2A" OR it = "33" OR it = "34") of last 2 of (first 5 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it)) & (" (Service Pack 2)") & (" (" & concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of it as string & "\Microsoft Shared\Office10"))) as string) & ")")) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry); (if (exists key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0050048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "28" OR it = "29" OR it = "2A" OR it = "33" OR it = "34") of last 2 of (first 5 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) AND (exists key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0050048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "28" OR it = "29" OR it = "2A" OR it = "33" OR it = "34") of last 2 of (first 5 of it)))) of (name of it)) AND (exists values "DisplayVersion" of it) AND ((value "DisplayVersion" of it as string < "11") AND (value "DisplayVersion" of it as string >= "10.0.6501.0"))) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) then (((value "DisplayName" of it as string) of (key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0050048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "28" OR it = "29" OR it = "2A" OR it = "33" OR it = "34") of last 2 of (first 5 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it)) & (" (Service Pack 3)") & (" (" & concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of it as string & "\Microsoft Shared\Office10"))) as string) & ")")) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry) ;(if (exists key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0150048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "CA" OR it = "E3") of last 2 of (first 5 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) AND (exists key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0150048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "CA" OR it = "E3") of last 2 of (first 5 of it)))) of (name of it)) AND (exists values "DisplayVersion" of it) AND ((value "DisplayVersion" of it as string < "11.0.6357.0") AND (value "DisplayVersion" of it as string >= "11"))) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) then (((value "DisplayName" of it as string) of (key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0150048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "CA" OR it = "E4") of last 2 of (first 5 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it)) & (" (No Service Pack)") & (" (" & concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of it as string & "\Microsoft Shared\Office11"))) as string) & ")")) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry); (if (exists key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0150048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "CA" OR it = "E3") of last 2 of (first 5 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) AND (exists key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0150048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "CA" OR it = "E3") of last 2 of (first 5 of it)))) of (name of it)) AND (exists values "DisplayVersion" of it) AND ((value "DisplayVersion" of it as string < "11.0.6568.0") AND (value "DisplayVersion" of it as string >= "11.0.6255.0"))) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) then (((value "DisplayName" of it as string) of (key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0150048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "CA" OR it = "E4") of last 2 of (first 5 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it)) & (" (Service Pack 1)") & (" (" & concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of it as string & "\Microsoft Shared\Office11"))) as string) & ")")) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry); (if (exists key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0150048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "CA" OR it = "E3") of last 2 of (first 5 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) AND (exists key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0150048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "CA" OR it = "E3") of last 2 of (first 5 of it)))) of (name of it)) AND (exists values "DisplayVersion" of it) AND ((value "DisplayVersion" of it as string < "11.0.8174.0") AND (value "DisplayVersion" of it as string >= "11.0.6568.0"))) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) then (((value "DisplayName" of it as string) of (key whose ((((length of it = 38) AND (it contains "-6000-11D3-8CFE-0150048383C9}" AND ((it = "11" OR it = "12" OR it = "13" OR it = "CA" OR it = "E4") of last 2 of (first 5 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it)) & (" (Service Pack 2)") & (" (" & concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of it as string & "\Microsoft Shared\Office11"))) as string) & ")")) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry) ;(if exists folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of registry as string & "\Microsoft Shared\Office12") whose (exists folder whose (exists file "MSOINTL.DLL" of it) of it) AND (exists key whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002E" OR it = "002F" OR it = "0030" OR it = "0031" OR it = "0033" OR it = "0035" OR it = "00CA") of last 4 of (first 14 of it)))) of (name of it)) AND (exists values "DisplayVersion" of it) AND ((value "DisplayVersion" of it as string < "12.0.4518.1014") AND (value "DisplayVersion" of it as string >= "12"))) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) then ((it & (" (No Service Pack)") & (" (" & concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of registry as string & "\Microsoft Shared\Office12"))) as string) & ")")) of ((value "DisplayName" of it as string) of (keys whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002E" OR it = "002F" OR it = "0030" OR it = "0031" OR it = "0033" OR it = "0035" OR it = "00CA") of last 4 of (first 14 of it)))) of (name of it)) AND exists value "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry)) whose(exists it)) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry) ; (if exists folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of registry as string & "\Microsoft Shared\Office12") whose (exists folder whose (exists file "MSOINTL.DLL" of it) of it) AND (exists key whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002E" OR it = "002F" OR it = "0030" OR it = "0031" OR it = "0033" OR it = "0035" OR it = "00CA") of last 4 of (first 14 of it)))) of (name of it)) AND (exists values "DisplayVersion" of it) AND ((value "DisplayVersion" of it as string < "12.0.6213.1000") AND (value "DisplayVersion" of it as string >= "12.0.4518.1014"))) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) then ((it & (" (Service Pack 1)") & (" (" & concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of registry as string & "\Microsoft Shared\Office12"))) as string) & ")")) of ((value "DisplayName" of it as string) of (keys whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002E" OR it = "002F" OR it = "0030" OR it = "0031" OR it = "0033" OR it = "0035" OR it = "00CA") of last 4 of (first 14 of it)))) of (name of it)) AND exists value "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry)) whose(exists it)) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry); (if exists folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of registry as string & "\Microsoft Shared\Office12") whose (exists folder whose (exists file "MSOINTL.DLL" of it) of it) AND (exists key whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002E" OR it = "002F" OR it = "0030" OR it = "0031" OR it = "0033" OR it = "0035" OR it = "00CA") of last 4 of (first 14 of it)))) of (name of it)) AND (exists values "DisplayVersion" of it) AND ((value "DisplayVersion" of it as string < "12.0.6425.1000") AND (value "DisplayVersion" of it as string >= "12.0.6213.1000"))) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) then ((it & (" (Service Pack 2)") & (" (" & concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of registry as string & "\Microsoft Shared\Office12"))) as string) & ")")) of ((value "DisplayName" of it as string) of (keys whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002E" OR it = "002F" OR it = "0030" OR it = "0031" OR it = "0033" OR it = "0035" OR it = "00CA") of last 4 of (first 14 of it)))) of (name of it)) AND exists value "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry)) whose(exists it)) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry); (if exists folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of registry as string & "\Microsoft Shared\Office12") whose (exists folder whose (exists file "MSOINTL.DLL" of it) of it) AND (exists key whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002E" OR it = "002F" OR it = "0030" OR it = "0031" OR it = "0033" OR it = "0035" OR it = "00CA") of last 4 of (first 14 of it)))) of (name of it)) AND (exists values "DisplayVersion" of it) AND ((value "DisplayVersion" of it as string < "13") AND (value "DisplayVersion" of it as string >= "12.0.6425.1000"))) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) then ((it & (" (Service Pack 3)") & (" (" & concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of registry as string & "\Microsoft Shared\Office12"))) as string) & ")")) of ((value "DisplayName" of it as string) of (keys whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002E" OR it = "002F" OR it = "0030" OR it = "0031" OR it = "0033" OR it = "0035" OR it = "00CA") of last 4 of (first 14 of it)))) of (name of it)) AND exists value "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry)) whose(exists it)) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry) ;(if (exists (exists (it as string & "\Microsoft Shared\Office14") whose(exists folder it whose(exists folder whose(exists file "MSOINTL.DLL" of it) of it)) of (values "CommonFilesDir" of keys "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of it)) whose(it = true) of it) AND (exists (keys whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002F" OR it = "011D" OR it = "008B" OR it = "003D") of last 4 of (first 14 of it)))) of (name of it)) AND exists values "DisplayName" of it) of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it)) AND (exists key whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002F") of last 4 of (first 14 of it)))) of (name of it)) AND (exists values "DisplayVersion" of it) AND ((value "DisplayVersion" of it as string < "14.0.6026.1000") AND (value "DisplayVersion" of it as string >= "14"))) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) then (item 0 of it as string & (" (No Service Pack)") & (" (" & concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of item 1 of it as string & "\Microsoft Shared\Office14"))) as string) & ")")) of ((((values "DisplayName" of it as string) of (keys whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002F" OR it = "011D" OR it = "008B" OR it = "003D") of last 4 of (first 14 of it)))) of (name of it)) AND exists values "DisplayName" of it) of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it)), it)) of (if x64 of operating system then (x64 registry ; x32 registry) else registry) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry); (if (exists (exists (it as string & "\Microsoft Shared\Office14") whose(exists folder it whose(exists folder whose(exists file "MSOINTL.DLL" of it) of it)) of (values "CommonFilesDir" of keys "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of it)) whose(it = true) of it) AND (exists (keys whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002F" OR it = "011D" OR it = "008B" OR it = "003D") of last 4 of (first 14 of it)))) of (name of it)) AND exists values "DisplayName" of it) of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it)) AND (exists key whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002F") of last 4 of (first 14 of it)))) of (name of it)) AND (exists values "DisplayVersion" of it) AND ((value "DisplayVersion" of it as string < "14.0.7015.1000") AND (value "DisplayVersion" of it as string >= "14.0.6026.1000"))) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) then (item 0 of it as string & (" (Service Pack 1)") & (" (" & concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of item 1 of it as string & "\Microsoft Shared\Office14"))) as string) & ")")) of ((((values "DisplayName" of it as string) of (keys whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002F" OR it = "011D" OR it = "008B" OR it = "003D") of last 4 of (first 14 of it)))) of (name of it)) AND exists values "DisplayName" of it) of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it)), it)) of (if x64 of operating system then (x64 registry ; x32 registry) else registry) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry); (if (exists (exists (it as string & "\Microsoft Shared\Office14") whose(exists folder it whose(exists folder whose(exists file "MSOINTL.DLL" of it) of it)) of (values "CommonFilesDir" of keys "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of it)) whose(it = true) of it) AND (exists (keys whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002F" OR it = "011D" OR it = "008B" OR it = "003D") of last 4 of (first 14 of it)))) of (name of it)) AND exists values "DisplayName" of it) of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it)) AND (exists key whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002F") of last 4 of (first 14 of it)))) of (name of it)) AND (exists values "DisplayVersion" of it) AND ((value "DisplayVersion" of it as string < "15") AND (value "DisplayVersion" of it as string >= "14.0.7006.1000"))) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) then (item 0 of it as string & (" (Service Pack 2)") & (" (" & concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of item 1 of it as string & "\Microsoft Shared\Office14"))) as string) & ")")) of ((((values "DisplayName" of it as string) of (keys whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002F" OR it = "011D" OR it = "008B" OR it = "003D") of last 4 of (first 14 of it)))) of (name of it)) AND exists values "DisplayName" of it) of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it)), it)) of (if x64 of operating system then (x64 registry ; x32 registry) else registry) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry) ;(if (exists folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of it as string & "\Microsoft Shared\Office15") whose (exists folder whose (exists file "MSOINTL.DLL" of it) of it)) AND (exists key whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002F") of last 4 of (first 14 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) AND (exists key whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002F") of last 4 of (first 14 of it)))) of (name of it)) AND (exists values "DisplayVersion" of it) AND ((value "DisplayVersion" of it as string < "16") AND (value "DisplayVersion" of it as string >= "15"))) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) then (((value "DisplayName" of it as string) of (key whose ((((length of it = 38) AND (it contains "000000FF1CE}" AND ((it = "0011" OR it = "0012" OR it = "0013" OR it = "0014" OR it = "002F") of last 4 of (first 14 of it)))) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it)) & (" (No Service Pack)") & (" (" & concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of it as string & "\Microsoft Shared\Office15"))) as string) & ")")) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry); (if (exists ((if (exists folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of x32 registry as string & "\Microsoft Shared\Office15") whose (exists folder whose (exists file "PIDGENX.DLL" of it) of it)) then (x32 registry) else( if(exists x64 registry) then (if (exists folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of x64 registry as string & "\Microsoft Shared\Office15") whose (exists folder whose (exists file "PIDGENX.DLL" of it) of it)) then (x64 registry) else (nothing)) else (nothing))), (if (exists key whose (name of it as lowercase contains "365proplus" AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of x32 registry) then (x32 registry) else ( if (exists x64 registry) then ( if (exists key whose (name of it as lowercase contains "365proplus" AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of x64 registry) then (x64 registry) else (nothing)) else (nothing))))) then ((((value "DisplayName" of it as string) of (key whose (name of it as lowercase contains "365proplus" AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of item 1 of it)) & (" (" & concatenation ", " of (((language of version block of file "PIDGENX.DLL" of it) of (folders whose (exists file "PIDGENX.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of item 0 of it as string & "\Microsoft Shared\Office15"))) as string) & ")")) of ((if (exists folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of x32 registry as string & "\Microsoft Shared\Office15") whose (exists folder whose (exists file "PIDGENX.DLL" of it) of it)) then (x32 registry) else( if(exists x64 registry) then (if (exists folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of x64 registry as string & "\Microsoft Shared\Office15") whose (exists folder whose (exists file "PIDGENX.DLL" of it) of it)) then (x64 registry) else (nothing)) else (nothing))), (if (exists key whose (name of it as lowercase contains "365proplus" AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of x32 registry) then (x32 registry) else ( if (exists x64 registry) then ( if (exists key whose (name of it as lowercase contains "365proplus" AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of x64 registry) then (x64 registry) else (nothing)) else (nothing))))) else (nothing)); (if (exists ((exists key whose ((((it as lowercase contains "homebusiness")) of (name of it)) AND exists values "DisplayName" of it AND exists values "DisplayVersion" of it AND (((value "DisplayVersion" of it as string < "16") AND (value "DisplayVersion" of it as string >= "15"))) ) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) of it) whose(it = true) ) then ((((value "DisplayName" of it as string) of (key whose ((((it as lowercase contains "homebusiness")) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it)) & (" (No Service Pack)") & (" (" & (concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of it as string & "\Microsoft Shared\Office15"))) as string) | "") & ")"))) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry) whose(exists ((exists key whose ((((it as lowercase contains "homebusiness")) of (name of it)) AND exists values "DisplayName" of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) of it) whose(it = true))); (if (exists ((exists key whose ((((it as lowercase contains "singleimage")) of (name of it)) AND exists values "DisplayName" whose(it as string as lowercase contains "home and business") of it AND exists values "DisplayVersion" of it ) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) of it) whose(it = true) ) then ((((item 0 of it) & (if((item 1 of it < "14.0.6026.1000") AND (item 1 of it >= "14")) then(" (No Service Pack)") else(if((item 1 of it < "14.0.7015.1000") AND (item 1 of it >= "14.0.6026.1000")) then(" (Service Pack 1)") else(if((item 1 of it < "15") AND (item 1 of it >= "14.0.7015.1000")) then(" (Service Pack 2)") else(" ()")))) & (" (" & (concatenation ", " of (((language of version block of file "MSOINTL.DLL" of it) of (folders whose (exists file "MSOINTL.DLL" of it) of folder (value "CommonFilesDir" of key "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion" of item 2 of it as string & "\Microsoft Shared\Office15"))) as string) | "") & ")")) of ((value "DisplayName" of item 0 of it as string, value "DisplayVersion" of item 0 of it as string, item 1 of it) of (key whose ((((it as lowercase contains "singleimage")) of (name of it)) AND exists values "DisplayName" whose(it as string as lowercase contains "home and business") of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it, it)) )) else nothing) of (if x64 of operating system then (x64 registry ; x32 registry) else registry) whose(exists ((exists key whose ((((it as lowercase contains "singleimage")) of (name of it)) AND exists values "DisplayName" whose(it as string as lowercase contains "home and business") of it) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of it) of it) whose(it = true)))
5

Wow. I don’t know that I really want to try to debug that.

Just from a quick skim, I’m pretty sure that could be done more elegantly with a lot less relevance.

What is the expected result on the machines that are returning an error?

What are some real results from machines that are not returning an error?

I wonder if the info would be more easily retrieved from WMI.

Does this help: https://bigfix.me/analysis/details/2994711 ?