Ah, ok. If a computer belongs to more than one group, or to zero groups, we would get an error on ‘name of bes computer group of computer of it’. We’d need to use the plural ‘names of bes computer groups of computer of it’ to handle zero or plural results.
There’s also probably a copy/paste type there…try this one
(html "<table id=resultsTable class=sortable>" & html ("<th>Action Name</th><th>Computer Name</th><th>Group</th><th>OS</th><th>Status</th><th>Last Report Time</th>") & (it) & html "</table>")
of concatenations of trs of (
td of (item 0 of it) &
td of (item 1 of it) &
td of (item 2 of it) &
td of (item 3 of it) &
td of (item 4 of it) &
td of (item 5 of it))
of (name of action of it | "n/a",name of computer of it | "n/a", concatenation ";" of names of bes computer groups of computer of it | "n/a", operating system of computer of it | "n/a",detailed statuses of it,last report time of computer of it as string | "n/a") of results of bes actions whose ((name of it as lowercase contains "customer1 - ") and state of it is contained by "Open|Expired")