An example of a stored query that shows all incidents for which the last update was NOT made by a member of a particular group is as follows:
Type: Request
Where clause: (type = \'I\') AND (active=1) AND NOT (last_mod_by.[member]member_list.group IN U\'97A22CEE025B8D479C05DA528DE2C0CE\')
Note that the value provided for U need to be pre-determined.
Release: 12.6 or higher
Component: CA Service Desk Manager
Follow these steps to create and define the stored query: