Query to show time spent in different groups.

Please go to Reports- New Query Report and execute the below given query.

 

select woq.Workorderid “Request ID”, wo.title “Subject”, wo.description “Description”, qd.queuename &#8220…

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 disp

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