Hello all,
is there a way to create a stats which shows the number of logged in agents per day/week/month?
I would like to create an overview for management to show them how many people regularly log in as an agent.
Thanks,
Jill
Statistics: Online Agents per day
Moderator: crythias
-
- Znuny newbie
- Posts: 97
- Joined: 04 Aug 2006, 13:48
Statistics: Online Agents per day
OTRS3.1.11
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Statistics: Online Agents per day
I don't believe you'd be able to accomplish this retroactively as sessions delete when complete. There might be some way to change the code for "Delete" session to "archive" session to a different table or "create" to duplicate to a store-only table., but that's not something out of the box. Perhaps others might have a different idea. I think the double-create is probably a better idea, as, essentially, all it would take (after creating the storage schema) is duplicating the SQL code and changing the table in the second SQL instance in AuthSession.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask