SCSM 2012 - Query results fetching duplicated records RRS feed

  • Question

  • In SCSM, I have a request offering for new staff joining the company. The requester needs to select the new staff department from the result of a query where I selected the following:

    - Class: Active Directory User

    - Display Columns: Department

    But the problem, as shown below, is that it displays duplicated departments, since it actually fetches all my users in the AD:

    Is there a way to add the equivalent of a "select distinct" condition?

    Thanks and best regards.

    Wednesday, October 16, 2013 10:50 AM


  • unfortunately this is not possible in SCSM (the Query returns the 'Display' value for each user object).

    you can create a simple list but it requires manual update, or PS script to update the MP XML code of the related RO (that contains the simple list)

    Wednesday, October 16, 2013 11:28 AM