PS - Get-MessageTrackingLog, Get-TransportServer, SELECT S5KB AS : Support Portal

IF object_id('tempdb..#Counter') IS NOT NULL

BEGIN

DROP TABLE #Counter

END

CREATE TABLE #Counter (

S5KB VARCHAR(50)

, S10KB VARCHAR(50)

, S25KB VARCHAR(50)

, S50KB VARCHAR(50)

, S100KB VARCHAR(50)

, S256KB VARCHAR(50)

, S512KB VARCHAR(50)

, S1MB VARCHAR(50)

, S2MB VARCHAR(50)

, S5MB VARCHAR(50)

, S10MB VARCHAR(50)

, S15MB VARCHAR(50)

, S20MB INT

, S30MB INT

, SBig INT

)

INSERT INTO #Counter (

S5KB

, S10KB

, S25KB

, S50KB

, S100KB

, S256KB

, S512KB

, S1MB

, S2MB

, S5MB

, S10MB

, S15MB

, S20MB

, S30MB

, SBig

)

SELECT S5KB AS [<5KB]

, S10KB AS [Between 5KB and 10KB]

, S25KB AS [Between 10KB and 25KB]

, S50KB AS [Between 25KB and 50KB]

, S100KB AS [Between 50KB and 100KB]

, S256KB AS [Between 100KB and 256KB]

, S512KB AS [Between 256KB and 512KB]

, S1MB AS [Between 512KB and 1MB]

, S2MB AS [Between 1MB and 2MB]

, S5MB AS [Between 2MB and 5MB]

, S10MB AS [Between 5MB and 10MB]

, S15MB AS [Between 10MB and 15MB]

, S20MB AS [Between 15MB and 20MB]

, S30MB AS [Between 20MB and 30MB]

, SBig AS [Big]

FROM OpenExchangePSQuery

(

POWERSHELL, '

[Int] $5KB = $10KB = $25KB = $50KB = $100KB = $256KB = $512KB = $1MB = $2MB = $5MB = $10MB = $15MB = $20MB = $30MB = $big = 0

Get-TransportServer | Get-MessageTrackingLog -ResultSize Unlimited -Start "07/03/2016" -EventID RECEIVE | ? {$_.Source -eq "STOREDRIVER"} | Select TotalBytes | ForEach { If ($_.TotalBytes -lt 5KB) { $5KB++ }

If ($_.TotalBytes -ge 5KB -and $_.TotalBytes -lt 10KB) { $10KB++ }

If ($_.TotalBytes -ge 10KB -and $_.TotalBytes -lt 25KB) { $25KB++ }

If ($_.TotalBytes -ge 25KB -and $_.TotalBytes -lt 50KB) { $50KB++ }

If ($_.TotalBytes -ge 50KB -and $_.TotalBytes -lt 100KB) { $100KB++ }

If ($_.TotalBytes -ge 100KB -and $_.TotalBytes -lt 256KB) { $256KB++ }

If ($_.TotalBytes -ge 256KB -and $_.TotalBytes -lt 512KB) { $512KB++ }

If ($_.TotalBytes -ge 512KB -and $_.TotalBytes -lt 1MB) { $1MB++ }

If ($_.TotalBytes -ge 1MB -and $_.TotalBytes -lt 2MB) { $2MB++ }

If ($_.TotalBytes -ge 2MB -and $_.TotalBytes -lt 5MB) { $5MB++ }

If ($_.TotalBytes -ge 5MB -and $_.TotalBytes -lt 10MB) { $10MB++ }

If ($_.TotalBytes -ge 10MB -and $_.TotalBytes -lt 15MB) { $15MB++ }

If ($_.TotalBytes -ge 15MB -and $_.TotalBytes -lt 20MB) { $20MB++ }

If ($_.TotalBytes -ge 20MB -and $_.TotalBytes -lt 30MB) { $30MB++ }

If ($_.TotalBytes -ge 30MB) { $big++ }

}

$result = New-Object PSObject -Property @{

S5KB = $5KB

S10KB = $10KB

S25KB = $25KB

S50KB = $50KB

S100KB = $100KB

S256KB = $256KB

S512KB = $512KB

S1MB = $1MB

S2MB = $2MB

S5MB = $5MB

S10MB = $10MB

S15MB = $15MB

S20MB = $20MB

S30MB = $30MB

SBig = $big

}

$result

', POWERSHELL

)