Please find the queries given below to change the timezone for all customers. From the result of first query get the timezoneid and replace it in the second query instead of timezoneid = 615
1) select * from timezonedefinition where displayname like ‘%Israel%’;
2) update sduserprofile set timezoneid = 615 where userid in (select technicianid from helpdeskcrew);
If you are using postgres database, to connect to the database execute the command given below.
C:\ManageEngine\ServiceDeskPlus-MSP\pgsql\bin> psql.exe -p 65432 -U postgres -w servicedesk
If you are using MSSQL connect to SQL studio and execute two queries.
Note: Please take an application backup or SQL backup before executing the update query.