Hello everyone.
Please, I need your help.
I’m using the IBM BigFix Connector on the Spreadsheet to extract the fixlets of a Windows server group from a specific baseline.
The result is showed in an excel spreadsheet separated the data by “;” with server name and results Applicable, Installed and Outstanding Fixlets, respectively. OK.
Example of the Results from Connector Excel:
Name of the server; Applicable; Installed and Outstanding Fixlets
Server01; 1; 1; 0
Server02; 1; 0; 1
Server03; 1; 1; 0
Relevance Query Example:
(name of computer of it as string & “;” &
(if (exists last became relevant of it) then (1) else (0)) as string & “;” &
(if (exists last became nonrelevant of it and relevant flag of it = false) then (1) else (0) ) as string & “;” &
(if (relevant flag of it = true) then (1) else (0) ) as string) of results of elements of unions of ((sets of source fixlets of components of component groups of bes fixlets whose (baseline flag of it = true and name of it = “My Baseline Exemple - Dez/2017 - MS Office”)))
I’m comparing the results of this query in the Connector excel report with the “Fixlet Compliance by Computer Group (v2.0)”, and it’s giving me a big difference in the number of servers. Although, I’m using the same string (var relevanceCompliance) that is available on report “Fixlet Compliance by Computer Group (v2.0)”.
The problem is that the Excel Connector is not listing the servers that have a relevant (0), ie, only are listing the relevant defined as (1). For example, the expected results below are not reported.
Name of the server; Applicable; Installed; Outstanding Fixlets
Server04; 0; 0; 0
Server05; 0; 0; 0
Server06; 0; 0; 0
I understand that it may or not be applicable to fixlets for some servers. So, why, the same query lists from “Fixlet Compliance by Computer Group (v2.0)” report, give me all servers with relevance (0)?
Please, you have an idea?
Thank you very much.