I could use some help in looking at this relevance statement. The reporting works fine. However it does not capture actions that are created from baselines from Custom sites. I don’t see anything obvious. This currently does work. I don’t see why baselines from custom sites make any difference as this seems to focus on actions and computers.
<?relevance concatenations of trs of (td of html ("" & (if (exists name of computer of it) then (name of computer of it) else ("Name Missing")) & "") & td of (if (exists id of action of it) then (id of action of it as string) else ("ID Missing")) & td of html ("" & (if (exists name of action of it) then (name of action of it) else ("Action Name Missing")) & "") & td of (if (exists state of action of it) then (state of action of it) else ("Action State Missing")) & (if (exists status of it) then (if (status of it = bes action status fixed) then (td of (html "" & status of it as string & html "")) else (if (status of it = bes action status failed or status of it = bes action status error) then (td of (html "" & status of it as string & html "")) else (td of (status of it as string)))) else (td of "Action Status Missing")) & td of (if (exists time issued of action of it) then (((year of it as string & "-" & month of it as two digits & "-" & day_of_month of it as two digits) of date (local time zone) of it & " " & (two digit hour of it as string & ":" & two digit minute of it as string & ":" & two digit second of it as string) of time (local time zone) of it) of time issued of action of it) else ("Issued Time Missing")) & td of (if (exists start date of action of it and exists start time_of_day of action of it) then (((year of it as string & "-" & month of it as two digits & "-" & day_of_month of it as two digits) of date (local time zone) of it & " " & (two digit hour of it as string & ":" & two digit minute of it as string & ":" & two digit second of it as string) of time (local time zone) of it) of ((start date of it as string & " " & start time_of_day of it as string) as local time) of action of it) else (if (exists time issued of action of it) then ((((year of it as string & "-" & month of it as two digits & "-" & day_of_month of it as two digits) of date (local time zone) of it & " " & (two digit hour of it as string & ":" & two digit minute of it as string & ":" & two digit second of it as string) of time (local time zone) of it) of time issued of action of it)) else ("No Start Date"))) & td of (if (exists end date of action of it and exists end time_of_day of action of it) then (((year of it as string & "-" & month of it as two digits & "-" & day_of_month of it as two digits) of date (local time zone) of it & " " & (two digit hour of it as string & ":" & two digit minute of it as string & ":" & two digit second of it as string) of time (local time zone) of it) of ((end date of it as string & " " & end time_of_day of it as string) as local time) of action of it) else ("No End Date")) & td of (if (exists issuer of action of it and exists name of issuer of action of it) then (name of issuer of action of it) else ("Issued By Missing"))) of results of bes actions whose (exists end date of it and name of source fixlet of it starts with "MS" and now > ((end date of it as string & " " & end time_of_day of it as string & " " & local time zone as string) as time) and now - ((end date of it as string & " " & end time_of_day of it as string & " " & local time zone as string) as time) < 7*day) ?></table>