scripts/Get-AppDBTCountbyTier.ps1
|
<# .SYNOPSIS Gets the count of business transactions per registered tier of an Application .DESCRIPTION Gets the count of business transactions per registered tier of an Application .EXAMPLE #> function Get-AppDBTCountbyTier { [CmdletBinding()] param( # Application ID. [Parameter(Mandatory=$false,ValueFromPipeline)] $AppId, # Use the name of the application if you do not know the AppId. Less efficient than using the ID [Parameter(Mandatory=$false)] $AppName ) Begin { Write-AppDLog "$($MyInvocation.MyCommand)" } Process { $AppId = Test-AppId -AppDId $AppId -AppDName $AppName foreach ($id in $AppId) { $BTs = Get-AppDBTs -AppId $id $total = 0 $BTCounts = @() foreach($tier in $BTs.applicationComponentName | sort-object -Unique){ $total += ($BTs.applicationComponentName | Where-Object {$_ -eq $tier}).Count $BTCounts += [pscustomobject]@{ Tier = $tier BTCount = ($BTs.applicationComponentName | Where-Object {$_ -eq $tier}).Count } } $BTCounts | Sort-Object BTCount -Descending Write-Host "`nTotal: $total" -ForegroundColor Green } } } |