KACE Product Support Question

How to create a "find user" in the queue::Custom Fields section?

06/26/2012 2409 views

Tickets have the ability to find all assets and machines in the database (it has a filter on the side). I'm wondering if there is a way to have a same field for users from the database instead of assets and machines.

Any help would be much appreciated.



0 Comments   [ + ] Show comments


Community Chosen Answer


You can use
query: select full_name from USER
In a custom field to retunr all users in the KACE appliance

Answered 11/08/2012 by: jdornan
Red Belt

  • Very slick! Any limits on queries used in the custom fields?

    Just for the record, I tested this with the Custom Field set to Single Select and a slight modification to the query above:

    query: select full_name from USER order by full_name

    So that the names are in alphabetical order (by last name) and it works perfectly. Just retested with the field changed to Multiple Select and this also works fine. I may have to play with this a bit to see if I can restrict by label, as that would make this *very* useful...


All Answers


You could use a custom field to have a dropdown of all of the users, but it wouldn't have the filter options available. If you aren't already using the CC list field, then you can use that to query other users and change the label appropriately. 

Answered 06/27/2012 by: chucksteel
Red Belt



Thru below machine registry you can find the all the users of the current machine:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList\S-1-5-21-xxxxxxxxxx-xxxxxxxxx-xxxxxxxxx-xxxxxx

Answered 06/27/2012 by: dannyarya
Purple Belt


If I understand your question correctly, it sounds like you want to list the user of the machine in the ticket.  Personally, this is what I use the Submitter field for and have the tech working on the issue listed as the Owner.  Of course, I understand this wouldn't necessarily work for all environments, as well as why it would be useful to have a user field.

That being said, I don't believe there is currently a way for a custom field to pull from the Users database or to respond to what is populated in another field.  What I'm thinking of with that second option is similar to the Single Select field option, but act as a "child" Single Select field that would change depending on what was listed in the "parent" Single Select field (in your situation, the Machine field).  Same idea as this post:


Since that's currently not an option, you *could* create a Single Select field populated with all of the user names and select the appropriate one from the list.  Wouldn't be as slick as fields like the Submitter and Owner fields, and would require updating the Single Select list each time you have user adds/terms, but it's an option for now.


Answered 06/27/2012 by: jverbosk
Red Belt

  • Ahh that would be nice but i'd rather just make a custom field with just a text field.
    Like chucksteel said before. But when there's about 1000 users it's not the greatest choice of action.
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