/build/static/layout/Breadcrumb_cap_w.png

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
  • So you mean the ticket creator? - chucksteel 7 years ago
  • Yes, we just figured out actually that there is a "Created by" line that appears on the ticket after it is submitted. So our ticket requester selects a different submitter (because they are submitting on behalf of our users) it will still show who actually created the ticket. - josephwagner 7 years ago
  • I don't know what you mean by "currently logged in user". To the machine? To the Service Desk UI? Chuck mentions the creator, is that what you want to record? - JasonEgg 7 years ago
  • In our environment, we have a system setup where our users submit their tickets through a proxy/requester. This person receives the ticket information and currently enters it into SchoolDude.

    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

Answers (0)

Be the first to answer this question

Don't be a Stranger!

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

Sign up! or login

Share

 
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