(imported comment written by jessewk)
Does this query work for you?
concatenation "" of (html (it as string)) of (link of it, concatenation ";" of values of results (it, bes properties "Location by Subnet") , (if (exists comments of it) then (((if length of it = 1 then "0" & it as string else it as string) of (month of it as integer as string) & "-" & (if length of it = 1 then "0" & it as string else it as string) of (day_of_month of it as integer as string) & "-" & (year of it as string)) of date (local time zone) of timestamp of it & ": " & text of it) of comments of it else "No Comment")) of bes computers
On my deployment, the output looks like this:
BIGFIX-4C8ACE5B, , No Comment
BIGFIX-4C8ACE5B, , No Comment
BIGFIX-4C8ACE5B, , No Comment
BIGFIX-4C8ACE5B, , 03-16-2009: foo
BIGFIX-4C8ACE5B, , No Comment
IntelMac, , No Comment
BIGFIX-4C8ACE5B, , No Comment
BIGFIX-4C8ACE5B, , 03-16-2009: foo
BIGFIX-4C8ACE5B, , No Comment
I don’t have a ‘Location’ Property. If there was result for that property, it would be between the ‘, ,’