KACE Product Support Question
anyways to pull IP address
05/03/2016 628 views
any possibility to pull IP address of the user machine into Helpdesk page?
Answer Chosen by the Author
Please log in to answer
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