Know when your technicians login and logout of the ServiceDesk Plus portal

Know when your technicians login and logout of the ServiceDesk Plus portal

select aal.NAME "Last logged User" ,MAX(aas.USER_HOST) "IP Address",LONGTODATE(MAX(aas.OPENTIME)) "last login time", longtodate(max(aas.closetime)) "Last Logout Time" 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 GROUP BY aal.NAME

You can execute this SQL query through Reports -> New Query Report in the ServiceDesk Plus portal or use SQL Query Analyzer against the ServiceDesk Plus database.