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

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

2

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...

    John
Please log in to comment

Answers

0

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

Please log in to comment
0

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

Answered 06/27/2012 by: dannyarya
Purple Belt

Please log in to comment
0

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

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.
Please log in to comment
Answer this question or Comment on this question for clarity