Need relevance output in a desired format

Hi Team

I am creating a relevance which should provide the applicable data of a machine
but the output should be

computer_name, patch 1, patch2, patch3

q:(name of computer of it | “None”, concatenation ", " of name of fixlet of it | “None”) of (results from (bes fixlets whose (applicable computer count of it > 0 and name of site of it is “Enterprise Security”)) of bes computers) whose (exists last became relevant of it and exists remediated flag of it)
A: computer_name, Configure the Update Path of Office 365 - Office 365
A: computer_name, Set up Network Share for Office 365 - Office 2013
A: computer_name, Disable Office 365 Automatic Update - Office 2016
A: computer_name, Application Information for Office 365 - Office 2016
A: computer_name, Set up Network Share for Office 365 - Office 2016
A: computer_name, Configure the Update Source of Office 365 - Office 365
A: computer_name, Set up Network Share for Office 2016 - Office 2016
A: computer_name, Set up Network Share for Office 2021 - Office 2021
A: computer_name, Set up Network Share for Office 2019 - Office 2019
A: computer_name, Set up Network Share for Office 2024 - Office 2024
A: computer_name, Office 365 Change Any Channel to Monthly Enterprise Channel
A: computer_name, Office 365 Change Any Channel to Semi-Annual Channel

I am not able to put it in a desired format?

That would be difficult, because you need to change the structure so you are looping over a computer and collecting the fixlets, instead of looping over the fixlet and collecting the computers.

If you wanted the relevant fixlets for the computer, that would be easy -

(name of it, concatenation ", " of names of relevant fixlets whose (name of site of it = "Enterprise Security") of it) of bes computers

I’m not sure it’s efficient enough to be used at scale, but this is what I was able to come up with -

(name of item 0 of it, concatenation ", " of names of items 1 of (item 0 of it, elements of items 1 of it) whose (exists (results (item 0 of it, item 1 of it)) whose (remediated flag of it)))  of (elements of item 0 of it, item 1 of it) of (set of bes computers, set of fixlets whose (fixlet flag of it) of bes sites whose (name of it = "Enterprise Security"))
2 Likes