Set User Timezone Globally for both Requester and Technician
Kindly follow the Steps below to set common time zone for all user profile
Note : We strongly recommend to take a backup before executing any update query.
* Run the below query to fetch the current time zones available under Servicedeskplus-MSP. ( Report -> New Query Report). Choose the preferred timezoneid which needs to be applied to all the users
select * from timezonedefinition;
* Kindly stop the application service.
* Replace the timezone ID in below query.
update sduserprofile set timezoneid=<timezoneid>;
* Restart the application service and verify the status.
New to ADSelfService Plus?
Related Articles
How to set the requester field as logged in user
Go to Admin >> Field and Form Rules >> Create a rule with the below script var user = { name:$CS.getLoggedInUserLoginName(), id:$CS.getLoggedInUserId() }; $rf.setFieldValue('requester',user);Converting a requester to a technician
Please follow the below steps to convert a requester to a technician. Step 1 (If the requester is already added under MSP Requester): 1) Log in as an administrator. 2) Go to Admin tab>>MSP Details>>MSP Requester(Left hand column). 3) Click on the ...Queries to show time stamp and time taken to first response, first tech assign, first group assign and first status set time ( MSSQL )
Tested in MSSQL build (14306) MSSQL: First responded time: SELECT wo.WORKORDERID "Request ID", wo.TITLE "Subject", aau.FIRST_NAME "Requester", ti.FIRST_NAME "Technician", LONGTODATE(wo.CREATEDTIME) "Created Time", LONGTODATE(wo.RESPONDEDTIME) ...Timezone issue
For time zones which are wrongly showing, and for DST issues make use of the jar file. Download the attached zip file and extract the jar file. Login to the application server machine, and follow the steps below to resolve the issue, ...Technician change from history
This report is used to find who changed the Technician and how many technician handled the request. To make any changes to a query, refer to the KB article below. ...