How to create a "find user" in the queue::Custom Fields section?
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.
Thanks
Jon
Answers (4)
You can use
query: select full_name from USER
In a custom field to retunr all users in the KACE appliance
Comments:
-
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...
John - jverbosk 12 years ago
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.
Hi,
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
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:
http://www.itninja.com/question/category-subcategory-on-custom-fields
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.
John
Comments:
-
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. - SvaJonny 12 years ago
