Can anyone offer any help with a relevance statement that I am trying to write that will get the actions on a computer by its id?
I have a relevance statement that works if only one computer is targeted in the action. If multiple computers are targeted then an empty response is returned, no errors.
The relevance that I am using is:
(id of it, name of it | “”, state of it as string | “”, time issued of it as string | “”, start date of it as string | “” as string, start time_of_day of it as string | “” as string, status of it of results of it as string | “Not Reported”, detailed status of it of results of it as string | “”, utc time flag of it) of top level bes actions whose (id of targeted computers of it = 12345678 )
if I try to change this to:
(id of it, name of it | “”, state of it as string | “”, time issued of it as string | “”, start date of it as string | “” as string, start time_of_day of it as string | “” as string, status of it of results of it as string | “Not Reported”, detailed status of it of results of it as string | “”, utc time flag of it) of top level bes actions whose ((concatenation “,” of (ids of targeted computers of it as string)) contains “12345678”)
I get the error
Error: Singular expression refers to non-unique object.
This happens because status of it of results of it as string | “Not Reported”, detailed status of it of results of it as string | “” are returned for each computer that the action was targeted on.
Any suggestions on how I can also filter results of it for a specific computer by id so that a single value is returned?
Any help would be appreciated.