Email based Custom Fields - getting the "Select User to add" option in CC List

I'm trying to create a email custom field and what is being requested is a dropdown that provide a list of the available users and their email addresses, like this example.   


I haven't seen any option in Field Type to duplicate this, how can this be set up to be like the option in CC list?

0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 2 months ago
Red Belt

You can create this using an SQL statement within the custom field (but it is complex!!)

In your SMA go to service Desk > Configuration

The select Queues and your queue

Then click "Customize fields and layout" and scroll down to the custom field area.

Click the small blue question mark next to the Custom Field heading to show the help text.

There is an example something like  "query: select distinct(LOCATION) from USER"

Which doesnt actually work........but never mind ......move on.

So if you want a list of users or their email address you will need to build an SQL statement to use such as...


To do this you will need to add the users that you want to show into a label and then identify the label ID, that will be the value shown as 37 in the above example.

If you want to show email addresses rather than names change the USER.USER_NAME field to USER.EMAIL

  • Will this example be able to handle thousands of potential emails? - MC9921 2 months ago
    • I have no idea, but its the only option in KACE that you have......other than setting the custom field type to User - Hobbsy 2 months ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ