Get-SQLMonitorGroup doesn't do what one would expect.

Phil_Fact0r

I have three groups, Staging, Development and Production

Your documentation says this....

 

<div>&nbsp; -------------------------- EXAMPLE 1 --------------------------</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; PS C:\>Get-SqlMonitorGroup -Path 'Production', 'Accounting'<br></div>

if I do this in PowerShell...

Get-SQLMonitorGroup -path 'Staging','production','Development'

....I get this

<div>Failed to find group "Staging"</div><div>At C:\Program Files\WindowsPowerShell\Modules\RedgateSQM\RedgateSQM.psm1:736 char:9</div><div>+&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;throw "Failed to find group ""$($Path[0])""";</div><div>+&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</div><div>&nbsp; &nbsp; + CategoryInfo&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; : OperationStopped: (Failed to find group "Staging":String) [], RuntimeException</div><div>&nbsp; &nbsp; + FullyQualifiedErrorId : Failed to find group "Staging"</div>

when I feed the parameters in one at a time interactively the same thing happens. How do I get the groups as MonitoredObjects

Phil_Fact0r

I'll answer my own question about how to get a group. There is another Cmdlet called Get-SQLMonitorMainGroups that seems to do what I want. One then gets subgroups using Get-SqlMonitorSubGroups. I'm still mystified about what Get-SQLMonitorGroup does.