Query to get Open status timespent calculation
Version : 10609 DB : MSSQL OUTPUT : SELECT "wo"."WORKORDERID" AS "Request ID", sisd.STATUSNAME as "Changed From", sinsd.STATUSNAME as "Changed To", case when si.NEXTSTATUSID is NULL THEN cast(datediff(d , dateadd(s,datediff(s,GETUTCDATE() ,getdate())Requests and Tasks in the same view
I am trying to find a way to view all my technicians' currently assigned work. Their work may consist of requests assigned to them or tasks assigned to them from an open project. I'd like to see a view that shows both their open requests and open tasksQuery to get WorkLog timespent For Request and Project
Version:10500 DB:PGSQL SELECT ad.ORG_NAME AS "Account", COALESCE(wtk.WORKORDERID , wo.workorderid) "Module ID", to_timestamp((ct.createdtime)/1000)::TIMESTAMP "Time Spent Created Time",'Request' "Module", CONCAT(COALESCE(TRUNC(sum(ct.TIMESPENT)/3600000,0)),'Report containing all instance technicians linked to their roles
Dear team, I'm recently working on some technician's management items and need to find all my technicians' (+/- 100) roles. Is there a way I can simply extract a list of these individuals linking them to their roles? This would be much needed for a system
New to ADSelfService Plus?
Announcements
[Mastering Analytics Plus 6.0 webinar series] Explore IT’s first decision intelligence platform
Hi there, We are thrilled to kick off the first session of our upcoming five-part webinar series, where we walk through Analytics Plus 6.0—IT’s first-ever decision intelligence platform. While traditional analytics stop at telling you what happened, decision[Free e-book] The ultimate guide to overcoming help desk hurdles
Hello folks, Is your help desk struggling? Are frequent issues affecting productivity and service delivery? Wield proven strategies to overcome widespread inefficiencies that weigh down most help desks. This e-book addresses the following major challenges[Free webinar] 5 ways to measure and reduce your help desk's workload
Hello there, Is a near-constant flurry of tickets weighing down your help desk operations? When operating in a perpetual fire-fighting mode, we often fail to spot technicians' woes. Our latest webinar lays out strategies to catch the signs of a struggling[Free webinar] How to make the help desk your first line of cyberdefense
Hi folks, We're happy to bring you our latest webinar on making the help desk your first line of cyberdefense. Date and time: October 30, 2023 2pm AEST | 10am GMT | 10am PST Why attend this webinar? Cybersecurity is no longer restricted to security teams.[Free e-book] Beyond performance: A guide to measuring your IT technicians' skillsets
We prioritize tracking and optimizing the performance of help desk technicians, but often fail to account for how closely performance is tied to technician skillsets. Identifying individual skill levels of technicians is vital in understanding and improving
Most Discussed Topics
Report - Tickets older than X time and tickets with no replies
Good afternoon friends, Our COO asked we devise separate reports which will show him two things. 1. Any open/assigned/unassigned tickets which are older than 10 days 2. Any tickets that are open/assigned/unassigned that have no response. I'm fairly certainRequest status times report
I was asked to set up a report that shows the amount of time that a ticket was in each status. Open: How long was the ticket Open until it was set to "In Progress" In Progress: How long was the ticket In Progress until it was set to "Resolved/closed"