KACE Queue Custom Field Query for Currently Logged in User
In the K1000 in our service desk queue we are looking to have a custom field that will hold the currently logged in user. I have managed to select a user by their ID manually.
Example: query: SELECT FULL_NAME FROM USER WHERE ID='25'
But I would like to change ID to be a variable, unless someone knows a better way to deal with selecting the currently logged in user creating the entry.
4 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
As we have been working on configuring our K1000 service desk, we wanted to be able to have our users login and see/enter their own tickets in the future. We are planning on still maintaining the system of having tickets put in by a proxy/requester as well. If that person were to select themselves as the submitter the person who submitted the ticket to them would not be able to see it in the future if they were to login to the user console. I was wanting to have a custom field which would automatically be set to the person submitting the ticket and the "Submitter" field would be set to the person who put the ticket in to the requester. It wasn't until after I made this forum post that we noticed that at the top of all ticket entries there is a "Created by" field now that displayed who created the ticket. - josephwagner 7 years ago