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
( 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”
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)