How to clear the 'computer_system_offset' in the ILMT server connections ? - Support and Troubleshooting

How to clear the 'computer_system_offset' in the ILMT server connections ? Description  Description Once the connection is setup for ILMT - Integrations, how do we reset connection attribute 'computer_system_offset' to 0.

More details in the below docs:

https://docs.servicenow.com/bundle/paris-it-asset-management/page/product/software-asset-management2/task/set-up-ibm-platform.html

Procedure As of Kingston, the ability to edit the 'computer_system_offset' attribute on the connection record for ILMT - Integration is not available through the UI. Please use the steps below to reset the 'computer_system_offset' attribute:

1. On the instance, navigate to the sys_variable_value table 2. In 'variable' column search for computer_system_offset 3. Identify the record with value other than 0 and copy the sysID of the record. Place it in line 2 of the below scrip. This script is to be run from System Definition > Scripts-Background

var gr = new GlideRecord('sys_variable_value'); gr.get("c947ac6473102300c963534a7af6a729");//where the sys_id is the sys_id of the record in table "sys_variable_value" where the value is other than0 gs.info(gr.value); gr.setValue('value', 0); gr.update();