AppInsight for Exchange - Primary Active Manager

Engineer84

I'm looking to monitor an attribute of our Exchange Database Availability Group called 'PrimaryActiveManager'

I can't seem to find this attribute in the existing AppInsight for Exchange template.

This attribute is difficult to validate True or False since there is no order of preference like there is to ensure a database is mounted on server preference #1.

Instead I think I would have to compare the value to ensure it's set to the correct server.

How can I add a component to query "get-DatabaseAvailabilityGroup -status | select PrimaryActiveManager" and compare that value to one I enter?

christopher.t.jones123

@Engineer84, you could use a PowerShell script monitor to accomplish this. I don't have a SolarWinds instance or Exchange to test it but something like below would probably be enough to get you started. 

#import exchange powershell module
import 

$primaryActiveMaanger = Get-DatabaseAvailabilityGroup -Status | Select PrimaryActiveManager

if ($primaryActiveMaanger -eq 'Value you want to compare'){

    Write-Host 'Statistic: 0'
    Write-Host 'Message: The Primary Active Manager is $primaryActiveMaanger'
    Exit 0
}
else {
    Write-Host 'Statistic: 1'
    Write-Host 'Message: The Primary Active Manager is $primaryActiveMaanger'
    Exit 3
}

Additional resources regarding PowerShell script component monitors:

The Basics of PowerShell (Part 1)

The Basics of PowerShell (Part 2)

The Basics of PowerShell (Part 3)