I want to know the fixlet counts on each computer in my environment. It looks like this is the overall total, correct? I’m looking to create a report that has computer name and the number of fixlets outstanding. I used what you provided and put it in a table. Every computer shows the same result.
tr of concatenation of (th of "Computer Name" & th of "Patches by Severity") &
concatenation of trs of (
td of (item 0 of it as string) &
td of (item 1 of it as string)
) of (
(name of it) of bes computers,
concatenation "; " of
((multiplicity of it as string) & " " & (concatenation "" of matches (case insensitive regex "[a-z]") of it)) of
unique values of (source severity of it | "undefined") of
Fixlets whose (
category of it is contained by set of ("Security Update";"Security Hotfix")
AND exists default action of it
AND Fixlet flag of it and name of it as lowercase contains "windows"
AND name of it as lowercase does not contain "superseded"
) of bes sites whose (name of it is contained by set of ("Enterprise Security";"Win2008ESU"))