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
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) ...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);Script to set Change Approver based on the Requester's Reporting to
Tested in build 14306 Requirement: When a change is created, the Change Approver role is to be filled automatically with the Change Requester's "Reporting to" user. Steps: >> Attached are the contents for Global and Change Custom Functions. >> ...Query to show technician created time (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) PGSQL & MSSQL: SELECT AaaUser.FIRST_NAME "Technician Name", aci.emailid "Email ID", LONGTODATE(AaaUser.createdtime) "Technician Created Time", SDUSER.STATUS "Status(Active/Inactive)" FROM AaaUser left ...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 ...