[cisco-voip] Generate BusyHOur from CDRs?

[Sean Watkins]

Hi,
Not really a VoIP question, but anyone have any idea of how to create some
busy hour reports from CDRs in SQL? I'll share my results! I need to size
some trunk groups for 5300 which can't create a busy hour report.



I have CDRs, looking like:

callstart callend
2005-03-09 15:56:00.000 2005-03-10 02:27:00.000
2005-03-09 18:47:00.000 2005-03-10 07:42:00.000
2005-03-09 21:29:00.000 2005-03-10 00:56:00.000
2005-03-09 22:24:00.000 2005-03-10 00:05:00.000
2005-03-09 23:09:00.000 2005-03-10 07:11:00.000
2005-03-09 23:47:00.000 2005-03-10 00:42:00.000
2005-03-10 00:09:00.000 2005-03-10 00:10:00.000
2005-03-10 00:26:00.000 2005-03-10 00:27:00.000
2005-03-10 00:31:00.000 2005-03-10 00:35:00.000
2005-03-10 00:33:00.000 2005-03-10 00:34:00.000
2005-03-10 00:36:00.000 2005-03-10 01:36:00.000
2005-03-10 00:50:00.000 2005-03-10 00:58:00.000
2005-03-10 01:05:00.000 2005-03-10 01:41:00.000


What I want todo, is find the bussiest hour --

Hour	ActiveCalls

2005-03-09 00:00 15

Sean Watkins