Overview

One is looking for a way to generate a report that contains the times agents are available. The idea is to obtain the total logged-in time for each agent on a daily basis and for a specific time range.

Information

The login times can be found on the Admin Panel> Logs> Login log area; however, the data there cannot be extracted and it is not possible to create a custom report using KQL either.

Having said that, one can obtain this information directly from the database and parse the data to generate the total login times. This would involve having your database admin query the swstaffloginlogtable and then parse the data using SQL or another tool such as Excel. Below one can find some helpful points on the process.

• The logs in the table swstaffloginlog are constantly purged, and the storage duration can be configured by updating Admin Control Panel > Settings > Server settings and performance > Log retention time. This way one can keep the login history for a longer period.
• The logindateline and logoutdateline columns in the table contain the respective login and logout time in epoch time and one can calculate the total logged-in time by subtracting them.
• The interfacetype column contains the area/platform where the user logged in. (1 = Staff CP, 2 = Admin CP, 5 = Winapp/Mobile apps).
• To include further details of the staff in the report such as their e-mail, one can join/use the swstafftable.