Have you tried the Work Queues internal object action 'Get Report Data'? It should get exactly what you need. It takes inputs such as 'Resource Names' and Start/End Dates. It outputs things like 'Time Total', 'Item Count', etc.
Respectfully,
Dave
Dave Morris, 3Ci at Southern Company