SELECT TOP 100 PERCENT dbo.moaAddressMap.MappedValue,

COUNT(dbo.moaMessage.ID) AS [Anzahl Nachrichten],

AVG(dbo.moaMessage.MsgSize) AS Durchschnittsgroesse,

MAX(dbo.moaMessage.MsgSize) AS [Groesste Nachricht],

MIN(dbo.moaMessage.MsgSize) AS [Kleinste Nachricht],

SUM(dbo.goaEngineDetail.ProcessDuration) AS Verarbeitungszeit

FROM dbo.moaMessage INNER JOIN dbo.moaAddressMap

ON dbo.moaMessage.Sender = dbo.moaAddressMap.MapID

INNER JOIN dbo.goaEngineDetail ON dbo.moaMessage.ID =

dbo.goaEngineDetail.ID INNER JOIN dbo.moaReceiptDetail ON

dbo.moaMessage.ID = dbo.moaReceiptDetail.ID GROUP BY

dbo.moaAddressMap.MappedValue ORDER BY AVG

(dbo.moaMessage.MsgSize) DESC

 

Back