Is there a list of commonly used queries for help desk custom fields. I am setting up a help desk, but I don't know sql. I am looking for queries I can cut and paste into the custom fields in the que customization  --> Ticket layout section. Things like auto populating a field with a machine name or IP Address.

 

Thanks

1 Comment   [ + ] Show Comment

Comments

  • Well there isn't a list per say. You will have to do searches here and find the articles. There are a ton of queries here that you could use.

    The machine name should auto populate anyways if the user sends in a email to open a ticket or go through the user portal.
Please log in to comment

Answers

1

Here are a couple of examples:

http://www.itninja.com/blog/view/using-sql-queries-in-custom-ticket-fields

http://www.itninja.com/question/how-to-create-a-find-user-in-the-queue-custom-fields-section

http://web01.itninja.com/question/k1000-service-desk-unexpected-behavior-with-query-in-custom-field

Answered 06/06/2013 by: jknox
Red Belt

Please log in to comment
1

I use this to get a list of all my users on the kbox and put it in a single select drop down (for new hire account copy purposes, you can use it for "USER AFFECTED" if need be)

 

query: Select USER.FULL_NAME from USER where USER.FULL_NAME <> '%admin%' order by USER.FULL_NAME ASC

Answered 06/10/2013 by: Wildwolfay
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity