I am trying to develop a stored query to list the incidents created by members of a specific group.
I've tried this:
(log_agent.analyst.[member]member_list.group IN (\'ServiceDesk\') AND type = \'I\') results in a bad where clause.
type = 'I' AND (log_agent.[member]member_list.group.id IN U'347121C59DB6B140A9961713A2F3E1BA')
(and yes that is the correct UUID)
Results in zero. Being the point of contact, a majority of incidents are created by the ServiceDesk.
Thanks in advance!