anyways to pull IP address
any possibility to pull IP address of the user machine into Helpdesk page?
Answer Chosen by the Author
Yes, this is possible using a custom rule. The update statement would look like this:
update HD_TICKET as T
set T.CUSTOM_FIELD_VALUE10 = (select IP FROM MACHINE where ID = MACHINE) where
T.ID = <TICKET_IDS>;
I would set the default value of the custom field to 'Set on Save' and then use a select statement that matches tickets with 'Set on Save' as the value. You might also want to have the select statement only match tickets with a MACHINE_ID not equal zero.
SELECT * FROM HD_TICKET WHERE CUSTOM_FIELD_VALUE10 = 'Set on Save' and MACHINE_ID != 0
Answered 05/03/2016 by: chucksteel
Please log in to comment
log in to commentPlease