SQL query to find average resolved time

 

select aau.first_name “Technician”, convert(varchar(10),(avg(wo.RESOLVEDTIME)-avg(wo.createdtime))/1000/3600)+’:’+convert(varchar(10),((avg(wo.RESOLVEDTIME)-avg(wo.createdti…

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