BigFix Relevance to get relevant Patches of a site

Hello All,

I have written a relevance to Check the Relevant fixlets from a Custom Site.

     Q:number of relevant fixlets whose(exists values whose("Important" = it OR "Critical" = it OR "High" = it) of headers "X-Fixlet-Source-Severity" of it AND not exists values whose(it contains " (Superseded)") of headers "Subject" of it) whose (not exists (headers "X-Fixlet-Type" of it) whose (value of it is contained by set of ("Task";"Analysis";"Baseline")))of sites whose((name of it) ="EPPSite")
    A: 3
    T: 0.075 ms

Here - EPPSite is a custom site name, where i have 3 Fixltes applicable on the endpoint where i am evaluating the Relevance and it is giving me a correct output. - 3

Now the requirement is that i have device.json file and i want to take custom sitename as input (operating_system: EPPSite)

json File -
{
“epp”:“symantec”,
“operating_system”:“c”,
“operating_custom”:“EPPSite”,
“third_party_apps”:“b”,
“third_party_custom”:“trd12”
}
Now I have written relevance which will read the value of key of json file as an input to read the sitename.

Q:(values of keys "operating_custom" of jsons of files "C:\Users\bigfix\Downloads\QNA10.0.8.37\device.json")
A: EPPSite
T: 0.048 ms

I an able to get the required sitename, now i have to use that relevnce in the relevance to check applicable patches from a custom site.

I Tried a couple of things.
1.Q:number of relevant fixlets whose(exists values whose("Important" = it OR "Critical" = it OR "High" = it) of headers "X-Fixlet-Source-Severity" of it AND not exists values whose(it contains " (Superseded)") of headers "Subject" of it) whose (not exists (headers "X-Fixlet-Type" of it) whose (value of it is contained by set of ("Task";"Analysis";"Baseline")))of sites whose((name of it) ="(values of keys 'operating_custom' of jsons of files 'C:\Users\bigfix\Downloads\QNA10.0.8.37\device.json')")
I: Current Selection Evaluation
A: 0
T: 2.174 ms

It is giving me 0 as output which is not the desired output as it is 3
2nd i tried -

Q:number of relevant fixlets whose(exists values whose("Important" = it OR "Critical" = it OR "High" = it) of headers "X-Fixlet-Source-Severity" of it AND not exists values whose(it contains " (Superseded)") of headers "Subject" of it) whose (not exists (headers "X-Fixlet-Type" of it) whose (value of it is contained by set of ("Task";"Analysis";"Baseline")))of sites whose((name of it) ="(values of keys "operating_custom" of jsons of files 'C:\Users\bigfix\Downloads\QNA10.0.8.37\device.json')")
E: The operator "operating_custom" is not defined.

i got the error.

3rd I tried this.

Q:number of relevant fixlets whose(exists values whose("Important" = it OR "Critical" = it OR "High" = it) of headers "X-Fixlet-Source-Severity" of it AND not exists values whose(it contains " (Superseded)") of headers "Subject" of it) whose (not exists (headers "X-Fixlet-Type" of it) whose (value of it is contained by set of ("Task";"Analysis";"Baseline")))of sites whose((name of it) ="(values of keys "operating_custom" of jsons of files "C:\Users\bigfix\Downloads\QNA10.0.8.37\device.json")")
E: The operator "operating_custom" is not defined.

But same issue, can some one please help in this.

I suspect your JSON inspection is returning a plural json result and the data you need for the site name is a singular string. Maybe just inspecting the “value” and not “values” and then cast to a string may work.

number of relevant fixlets whose (exists values whose ("Important" = it OR "Critical" = it OR "High" = it) of headers "X-Fixlet-Source-Severity" of it AND not exists values whose (it contains " (Superseded)") of headers "Subject" of it) whose (not exists (headers "X-Fixlet-Type" of it) whose (value of it is contained by set of ("Task";"Analysis";"Baseline")))of sites whose ((name of it) = ((value of keys "operating_custom" of jsons of files "C:\Users\bigfix\Downloads\QNA10.0.8.37\device.json") as string))

1 Like

@SLB - Thanks a lot for reply it helped.

1 Like