Combining query

(imported topic written by jc811591)

I want to search critical patches with something like this that reports computers and # of critical patches for each

name of it, number of relevant fixlets whose (value of header “x-fixlet-source-severity” of it as lowercase = “critical”) of site “enterprise security”

and i want to add if there are none say that it is patched. can’t i do that with if then else statement, like

if () then

(number of relevant fixlets whose (value of header “x-fixlet-source-severity” of it as lowercase = “critical”) of site “enterprise security”

)

else “Patched”

Not sure if this is at all close, or how i would go about it

(imported comment written by BenKus)

Hey jc8115,

Is this similar to the report you are looking for?

http://forum.bigfix.com/viewtopic.php?id=898

Ben

(imported comment written by jc811591)

( html (it &","& multiplicity of it as string &","))of unique values of (link of it as string) of (applicable computers of it) whose(exists link of it) of bes fixlets whose( globally visible flag of it AND (name of site of it as lowercase contains “patch” or name of site of it = “Enterprise Security”) AND (source severity of it as lowercase as string = “critical” ))

how do you add if there is no patch needed for it to display “patched”

(imported comment written by BenKus)

This is tricky because the computer won’t even show up if it doesn’t have any patches… but here is a solution, add an entry for each computer and if you only see the computer once, then it must mean that it doesn’t need any patches:

(html (it &","& (if (multiplicity of it = 1) then “Patched” else multiplicity of it as string &","))) of unique values of ((link of it as string) of (applicable computers of it) whose(exists link of it) of bes fixlets whose(globally visible flag of it AND (name of site of it as lowercase contains “patch” or name of site of it = “Enterprise Security”) AND (source severity of it as lowercase as string = “critical”));links of bes computers whose (exists link of it) as string)

Ben