I’m new to Bigfix and first time trying to use reporting to show any MS Office Suite installed on all systems.
I have the following relevance that I copied form this forum:
<table> <?relevance trs of (td of name of it & td of concatenation
"," of (values of result (it, bes property
"School Name by IP Range")) & td of concatenation
"," of (values of result (it, bes property
"Installed Applications - Windows")) whose (it as lowercase contains
"microsoft office")) of bes computers whose (exists (value of result (it, bes property
"Installed Applications - Windows")) whose (it as lowercase contains
"microsoft office") AND exists (value of result (it, bes property
"School Name By IP Range"))) ?> </table>.
Perhaps an easier way to get Microsoft Office information will be to use the built-in “Microsoft Office Suite Information (Windows)” Analysis. Make sure it is activated and then you can go to “Create Report” in the web reports and choose the “Analysis Report”. You can then filter the report using the filter button if you want.
Finally I was able to get the report that I want, but for some reason few of the outputs are .
Is there a way to avoid ?
Here is the code that I’m using to get microsoft office info:
unique values of ((
if (exists value
"DisplayVersion" of it AND exists value
"DisplayName" of it) then (value
"DisplayName" of it as string &
" - " & value
"DisplayVersion" of it as string)
else (
if (exists value
"DisplayName" of it AND not exists value
"DisplayVersion" of it) then (value
"DisplayName" of it as string &
" - <N/A>")
else nothings)) of keys whose (value
"DisplayName" of it as string as lowercase contains
"microsoft office" AND value
"DisplayName" of it as string as lowercase does not contain
"elements" AND value
"DisplayName" of it as string as lowercase does not contain
"update") of key
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry)