Agent_Interval Table - DateTime and ReportingHalfHour Correlation

[brooks.ritchie1]

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

[geoff]

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

[brooks.ritchie1]

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.