SELECT woaUserMap.MappedValue AS [user],

COUNT(woaTransactionDetail.[ID]) AS requests,

COUNT(DISTINCT goaMachineIDMap.MapID) AS sites,

(SUM(woaTransactionDetail.ResponseLength)/1024) AS kbxfer

FROM woaUserMap INNER JOIN woaTransactionDetail woaTransactionDetail

ON woaUserMap.MapID = woaTransactionDetail.UserId INNER JOIN

goaMachineIDMap goaMachineIDMap ON woaTransactionDetail.DomainId =

goaMachineIDMap.MapID WHERE woaTransactionDetail.RequestTime

BETWEEN '2003-04-01' AND DATEADD(d,-1,'2003-05-01') GROUP BY

woaUserMap.MappedValue ORDER BY requests DESC

 

Back