02-01-2018 11:54 AM - edited 03-15-2019 06:35 AM
I am working on a report for Agent usage and am creating queries against the Agent_Interval database table. I'm checking the ReportingHalfHour field along with the DateTime field and am assuming that the ReportingHalfHour should always correspond to the same DateTime slot every day. For example, ReportingHalfHour 0 should associate with DateTime 00:00, ReportingHalfHour 1 with DateTime 00:30, etc. In looking at the data in the Agent_Interval table that doesn't appear to be the case. Is my assumption wrong on this?
DateTime ReportingHalfHour SkillTargetID LoggedOnTime
2018-01-10 19:00:00 0 5016 900
2018-01-10 19:15:00 0 5016 900
2018-01-10 19:30:00 1 5016 900
2018-01-10 19:45:00 1 5016 900
Thanks
02-01-2018 06:38 PM
The original interval from the GeoTel days was 30 minutes. A few years ago, Cisco provided the option to make the interval 15 minutes, which you obviously have set. I am sure you know this.
Quite honestly, I have never used the "ReportingHalfHour" column. What do you want to use this for?
Regards,
Geoff
02-02-2018 08:23 AM
Thanks for your reply. I was thinking about using the ReportingHalfHour column to track the sum of minutes all agents were logged in for each half hour period using the LoggedOnSeconds column.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide