Trigger Condition for Powershell Monitor Using "Statistic"

wazm

Hi all.  I've been tasked with creating an alert for a powershell component monitor that returns two different sets of messages/statistics and disadvantaged in that I have no experience to speak of and the need is urgent.  I've managed to cobble together a working alert however my current trigger condition, based on on the "critical" state of the component, is not sufficient.

The monitor returns two values (example below):

Statistic.count      4

Statistic.percentage      23

In the above example 4 is bad and 23 is good so I don't want the alert to trigger but it will because Statistic.count is in a critical state based on the thresholds I set. 
What I need is to create a trigger condition that says if statistics.count < 5 AND statistic.percentage < 5 then send an email.

I've read some about using ${StatisticData} though I don't know how to use it to return two different stats.  Is there a way to do what I need?  How?

Thanks for reading, any help you can offer is greatly appreciated.

christopher.t.jones123

@wazm I haven't tested this, but the below addition to your script should get the job done. It'll display all the statistics you gather but at the end, if the condition you described is true it will then set the component to critical, if it's not true it'll set the component to up. With the logic in the script, your alert trigger condition can continue to just look at the status of the component. Let me know how it works.

Function Connect-MSOnline {
$user = <account>
$encrypted = Get-Content <path> | ConvertTo-SecureString -Key (Get-Content <path>)
$credential = New-Object System.Management.Automation.PsCredential($user, $encrypted)
Connect-MsolService -Credential $credential
}

Connect-MSOnline

$Licenses = Get-MsolAccountSku | Where-Object {$_.skuPartNumber -eq "DESKLESSPACK"}
$AvailableLicenses = $Licenses.ActiveUnits-$Licenses.ConsumedUnits
$TotalLicenses = $Licenses.ActiveUnits
$Percentage = [math]::Round($AvailableLicenses/$TotalLicenses*100)

Write-Host "Message.Available: Licenses Available"
Write-Host "Statistic.Available: $AvailableLicenses"
Write-Host "Message.Total: Total Licenses"
Write-Host "Statistic.Total: $TotalLicenses"
Write-Host "Message.Percent: Percent Available"
Write-Host "Statistic.Percent: $Percentage"

if ($AvailableLicenses -lt 5 -and $Percentage -lt 5){
	Write-Host "Message.Critical: Available Licenses is $AvailableLicenses and Percent Consumsed is $Percentage"
	Write-Host "Statistic.Critical: 1"
	Exit 3
}
Else {
	Write-Host "Message.Up: Available Licenses is $AvailableLicenses and Percent Consumsed is $Percentage"
	Write-Host "Statistic.Up: 0"
	Exit 0

}