Last login time query report
I am looking for a query to show the last login time of technicians of specific support group. Right now I have this query but it shows all technicians, I would like to limit the results to a specific support group:
select aal.NAME "Logged User" , MAX(aas.USER_HOST) "IP Address",LONGTODATE(MAX(aas.OPENTIME)) "Last Login time",MAX(au.First_Name) "Technician" from AaaAccSession aas LEFT JOIN AaaAccount aacc on aacc.ACCOUNT_ID=aas.ACCOUNT_ID LEFT JOIN AaaLogin aal on aal.LOGIN_ID=aacc.LOGIN_ID LEFT JOIN AaaUSer as au on aal.USER_ID=au.USER_ID WHERE aal.USER_ID in (select technicianid from helpdeskcrew) GROUP BY aal.NAME
ORDER BY 3 desc
Running SDP 9.2 Build 9234 with an MSSQL database.