Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Staffing/FTE counts in Symposium Call Center

Status
Not open for further replies.

jahillia

MIS
Nov 14, 2006
9
US
I am trying to do some staffing comparisons based on headcounts or FTE's. I have been able to find a table inside of Symposium called eAgentLoginStat that shows the total duration that an agent was logged in. This works great with the exception that it is only good for about 30 days. Can I get this from some other table? I found one colum from another table dAgentBySkillsetStat.TotalStaffedTime but it is WAY too high to be accurate.

Can anyone tell me where to get this information?

Thanks,
Jason
 
You should be able to adjust how long your report stats stay in memory. I think by default 30 days is set up. I forgot exactly where it is, maybe admin portion, but you can make the report information available as long as you have enough memory to so.
 
Select the 'Configuration' option, then 'Historical Stats'.

The parameter is set in the 'Duration' window.

I have some bespoke reports that show the number of concurrent agent logins across Symposium.

Report 1 shows the max agent logins on a daily basis

Report 2 shows the max agent logins on an interval basis by day

Report 3 shows the same as above but also includes the names of the agents that make up the interval totals.

I'm happy to share these with you if they will be of any use. I'd say let me know your email address, but I think that's against forum rules!!

DD
 
Thanks, I did find where to change the storage times, but that's an IT adjustment which would be a lot of work to get changed...I'm storing the data in an Access database. Dave, if you would use my username and combine that with a popular email service that starts with a Y! -- maybe you could get it to me :) I would like to see those!
 
Do you have SQL Server?

We use DTS packages to automatically back up all the data infinitely, for historical reporting purposes.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top