Restricting the Select User Window

Greg_Tate

Is it possible to scope the Select User window so that it only filters on certain criteria, such as an OU?

I'm referring to the Select User window for the Affected User or Requestor field, not the Assigned To User field. I'm aware of the Global Operators Group, which is used for Assigned To and Primary Owner. Would like to know if there's a similar group for Affected User and Requestor, or if there's a Cireson solution that helps make this happen.

Thanks in advance!

Brian_Wiest

Portal
Click your name top right 
Admin Settings
Settings Items
UserQuery 

Update the logic. 
Example I updated mine to make sure the affected user has an email address. (Stopping service accounts and security groups selection)

(DisplayName LIKE '%' + @Query + '%' OR UserName LIKE '%' + @Query + '%') AND EmailAddress1 IS NOT Null

Brian_Wiest

Portal
Click your name top right 
Admin Settings
Settings Items
UserQuery 

Update the logic. 
Example I updated mine to make sure the affected user has an email address. (Stopping service accounts and security groups selection)

(DisplayName LIKE '%' + @Query + '%' OR UserName LIKE '%' + @Query + '%') AND EmailAddress1 IS NOT Null

Greg_Tate

Thanks for the response, Brian. This puts us on the right track.

Lukas_Kocher1

Dear @Brian_Wiest
Can you please explain how i can configure the query that does it only view users which have a title
i tested already (and title is not '' ) or and title is not <> '')
Thank you
best regards

Brian_Wiest

If you check the SQL table CI$User you will see that tiles are blank not Null.
So you update to 
(DisplayName LIKE '%' + @Query + '%' OR UserName LIKE '%' + @Query + '%') AND Title not like ''

Lukas_Kocher1

@Brian_wiest
WoW now it works what i supost to have,
Thank you very much
best regards