Hi,
I want a single property relevance for Installed application details in Windows & Mac,
here (IBM Bigfix) have two property in bigfix console, so we cannot take the report in single filter column,
Please suggest any idea for this report generation using single filter,
Thanks,
Nagaraj,
what do you mean by ''report in single filter column" ?
Could you show us an example or desired output and actual output?
Hey Nagaraj,
Here’s an example of how to return different results for each OS:
(if (mac of operating system) then "Mac" else if (windows of operating system) then "Windows" else "Error")Hi,
Please find the sample reports page,
When I filter the column like (installed application- windows) Mac OS is not shown the column, or else I apply the filter like Installed application- Mac OS mean windows fields cannot shown,
This is my queries,
Thanks,
Nagaraj,
@Nagaraj, You need to create two separate report for each operating system.
This is the product behavior, It’ll show Installed App- windows only for Windows OS where as it’ll show for the other properties which you have created for MAC OS and vise-versa. 
That’s possible, just look at the example of @rustymyers and code yours!
Edit: Modified @rustymyers code, I hope this is what your lookin for.
(if (mac of operating system) then (name of it as string & " - " & (if(exists version of it) then(version of it as string) else(“N/A”))) of applications else if (windows of operating system) then unique values of ( ( (value “DisplayName” of it as string & (if (exists value “DisplayVersion” of it) then (" | " & value “DisplayVersion” 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 (“”))) 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 (“”))) 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 (“”)) 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 (“”))) 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 (“”))) 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 (“”))) 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 (“”))) 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 (“”))) 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 (“”))) 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 ) ) else “Error”)
Create it as a property in BigFix console and then try to add this property(Edit columns) in your webreports and Viola, you have your expected result.
