How to create a CA SDM stored query to show tickets where the CI is included in the current user's environment. This information is also available on the CI Contacts tab under Other Assigned Contacts.
The following Stored Query syntax will provide the desired results
active=1 and affected_resource.[nr]email@example.com