[cisco-voip] Generate BusyHOur from CDRs?

[Candace Holman]

Not sure this answers your question, but you can do this easily from CAR, 
the CDR Analysis and Reporting tool.  System Reports - System Overview, 
check the gateway reports.  Or Device Reports - Gateway Utilization.

Candace

At 02:55 PM 3/11/2005, Sean Watkins wrote:
>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
>
>_______________________________________________
>cisco-voip mailing list
>cisco-voip at puck.nether.net
>https://puck.nether.net/mailman/listinfo/cisco-voip