Common Helpdesk Custom Field Queries
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
Answers (2)
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
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
The machine name should auto populate anyways if the user sends in a email to open a ticket or go through the user portal. - nshah 11 years ago