Query to set the same timezone for all technicians


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.
This entry was posted in Assets.

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500