Know in a report the total time in hours that the Online technicians have been during the last week
Good afternoon,
please I need to create a report that indicates the total hours that technicians have been online in servicedesk plus during the last week.
I've been testing a series of queries with which the technician already shows, his last session and the number of times he has started, but none that make a sum of the total hours that have been online during the past week.
Would anyone know tell me?
this is all I've seen in the forum that most resembles:
SELECT dbo.AaaUser.FIRST_NAME AS [Full Name], MAX (dbo.AaaAccSession.OPENTIME) AS [Logged In Time], COUNT (dbo.AaaAccSession.SESSION_ID) AS [No of logins]
FROM dbo.AaaUser INNER JOIN
dbo.SDUser ON dbo.AaaUser.USER_ID = dbo.SDUser.USERID INNER JOIN
dbo.HelpDeskCrew ON dbo.SDUser.USERID = dbo.HelpDeskCrew.TECHNICIANID LEFT OUTER JOIN
dbo.AaaLogin ON dbo.AaaUser.USER_ID = dbo.AaaLogin.USER_ID INNER JOIN
dbo.AaaAccount ON dbo.AaaAccount.LOGIN_ID = dbo.AaaLogin.LOGIN_ID INNER JOIN
dbo.AaaAccSession ON dbo.AaaAccount.ACCOUNT_ID = dbo.AaaAccSession.ACCOUNT_ID
WHERE (dbo.SDUser.STATUS = 'ACTIVE')
GROUP BY dbo.AaaUser.FIRST_NAME
New to ADSelfService Plus?