How to create a CA Service Desk Manager (CA SDM) stored query to show tickets where the Configuration Item (CI) is included in the current user's environment

Document ID : KB000028870
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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.

Solution:

The following Stored Query syntax will provide the desired results

active=1 and affected_resource.[nr]cntref.cnt=@cnt.id