The easiest way, and the preferred way, is to make sure Agent Level reporting is turned on. In the Peripheral Explorer, on the CUCM PIM, in the Agent Distribution tab, ensure "Enable agent reporting" is checked. That's the default, so you are probably good.

Now open SQL query analyzer, point it at your AW or HDS and query the Agent_Half_Hour table making the following calculation (assumes you are only interested in the Cisco_Voice Media Routing Domain).

Set the start date appropriately.

declare @start datetime

declare @end datetime

set @start = '2009/10/19 0:00'

set @end = DATEADD(dd, 1, @start)

SELECT AHHAdjustedCount = MAX(AHHCount.AdjustedLoggedOn)

FROM (SELECT DateTime,

AgentsLoggedOn = Count(*),

AdjustedLoggedOn = Ceiling(SUM(LoggedOnTimeToHalf)/1800.0)

FROM Agent_Half_Hour AS AHH

WHERE DateTime >= @start

AND DateTime < @end

AND AHH.MRDomainID = 1

GROUP BY DateTime) AHHCount

Regards,

Geoff