/build/static/layout/Breadcrumb_cap_w.png

Service Desk Custom Field

I am configuring the service desk feature of the K1000 and would like to create a custom field. I would like to create a custom field to auto populate the email address of the user creating the request. WE have AD authentication. This information show up in the submitter field when you click on the person icon. but I would like to have a separate field that stores the email.
I tried this "query: select distinct(EMAIL) from USERS" in a single select field and it returns all the emails. I would like it to select the currently logged on users email.

any suggestions are appreciated. If I am not clear just ask and I will elaborate.

0 Comments   [ + ] Show comments

Answers (2)

Posted by: GillySpy 13 years ago
7th Degree Black Belt
1
you would need a ticket rule to do this. something like (note not tested so please test on a test queue and follow http://www.kace.com/support/kb/index.php?action=artikel&cat=8&id=689&artlang=en)

frequency=on ticket save

select query
select HD_TICKET.ID from HD_TICKET JOIN USER SUBMITTER ON SUBMITTER_ID=SUBMITTER.ID
WHERE CUSTOM_FIELD_VALUE0<>SUBMITTER.EMAIL


update query update HD_TICKET T JOIN USER SUBMITTER ON SUBMITTER_ID=SUBMITTER.ID
SET
/*assuming CUSTOM_1 is used */ CUSTOM_FIELD_VALUE0 = SUBMITTER.EMAIL
WHERE T.ID =<TICKET_IDS>
Posted by: ryklism 13 years ago
Orange Belt
1
thank you for the reply. I will give it a shot.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
 
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