Use this cmdlet to export a Management Pack to a specified path. Unlike the Operations Console, where you can only export unsealed Management Packs, using this cmdlet will export both sealed and unsealed Management Packs in XML format. First query...

Find Agent, by Health Service Id get-agent | where {$_.hostedHealthService.id -eq " guid "} | select-object name main menu

Evaluate whether alert grooming is working.  No result is good. $Threshold=(Get-Date).AddDays(-(get-defaultsetting)[42].Value-1).ToUniversalTime().Date.AddMinutes(30);Get-Alert | Where {$_.TimeResolved -and $_.TimeResolved -lt $Threshold} | Measure...

Be careful while deleting Management Packs.  I suggest to first query the Management Pack and verify you’re returning the one you want to delete. Return all Management Packs by Display Name get-managementpack | select displayName | sort displayName...

Approve Manual Installation for single agent Get-AgentPendingAction | where {$_.AgentName –match “ netbios_name ”} | Approve-AgentPendingAction Approve Manual Installation for all pending agents Get-AgentPendingAction | where {$_.AgentPendingActionType...

Resolve UIGeneratedMonitor to a Monitor Name get-monitor | where {$_.name -eq " UIGeneratedMonitor "} | select DisplayName main menu

Get BaseManagedEntityId for Agent get-agent | where {$_.ComputerName -eq " netbios_name "} | select {$_.HostedHealthService.id},name main menu

Use this commandlet to set Management Group global settings.  You can use its companion, get-DefaultSetting , to return the current Management Group global settings. Set Auto-Approve New Manually Installed Agents setting Set-DefaultSetting ManagementServer...

List connected users to SDK (console and command shell users) Get-ManagementGroupConnection | foreach-object {$_.ManagementGroup.getConnectedUserNames()} Count connected users Get-ManagementGroupConnection | foreach-object {$_.ManagementGroup.getConnectedUserNames...

Enable Agent Proxying, by Health Service Id $a=get-agent | where {$_.hostedHealthService.id -eq " guid "};$a.set_proxyingEnabled($true);$a.applyChanges() main menu

Resolve all open alerts generated by specific Agent get-alert | where {$_.netbiosComputerName -eq " netbios_name " -AND $_.resolutionState -ne 255} | Resolve-Alert To use Criteria Expression for better performance get-alert -criteria 'NetbiosComputerName...

All overrides, with settings Get-ManagementPack | where {$_.sealed -eq $false} | get-override | select-object name,parameter,module,rule,value main menu

10 most recent CRITICAL alerts (not closed) get-alert | where {$_.severity -eq "error" -and $_.resolutionstate -ne 255} | sort-object TimeRaised -desc | select-object -first 10 name,timeraised main menu

Top 10 alerts get-alert | Group-Object Name | Sort-object Count -desc | select-Object -first 10 Count, Name | ft –auto main menu

All rules overriden from specific MP foreach ($rule in Get-ManagementPack | where {$_.DisplayName -match " mp_display_name "} | get-override | where {$_.rule}) {get-rule | where {$_.Id -eq $rule.rule.id} | select-object DisplayName} main menu

Find collection rule that is writing specific performance object to the database Foreach ($rule in (get-rule | where {$_.category -eq "PerformanceCollection"} | foreach-object {$_.DataSourceCollection}))     {    ...

All monitors overriden from specific MP foreach ($monitor in Get-ManagementPack | where {$_.DisplayName -match " mp_display_name "} | get-override | where {$_.monitor}) {get-monitor | where {$_.Id -eq $monitor.monitor.id} | select-object DisplayName...

Overrides modified in date range Get-ManagementPack | where {$_.sealed -eq $false} | get-override | where {$_.LastModified.ToLocalTime().date -gt $_.TimeAdded.ToLocalTime().date -and $_.LastModified.ToLocalTime().date -ge " mm/dd/yyyy " -and...

Beware of word wrap. foreach ($rule in get-rule | where {$_.category -eq "EventCollection"} | foreach-object {$_.DataSourceCollection})     {     if ($rule.get_configuration().ToString() -match " event number...

Overrides that have been modified Get-ManagementPack | where {$_.sealed -eq $false} | get-override | where {$_.LastModified -gt $_.TimeAdded} | fl name,LastModified main menu

Overrides created in date range Get-ManagementPack | where {$_.sealed -eq $false} | get-override | where {$_.TimeAdded.ToLocalTime().date -ge " mm/dd/yyyy " -and $_.TimeAdded.ToLocalTime().date -le " mm/dd/yyyy "} | fl name,TimeAdded...

Resolve all open alerts, by Alert Name get-alert | where {$_.Name -eq " alert_name " -AND $_.resolutionState -ne 255} | resolve-alert main menu

This is a basic commandlet that returns Management Group global settings.  You can use it’s companion, set-DefaultSetting , to configure Management Group global settings. Return all Management Group global settings get-DefaultSetting Return Auto...

Resolve all open alerts in date range get-alert | where {$_.TimeRaised.ToLocalTime().date -ge " mm/dd/yyyy " -and $_.TimeRaised.ToLocalTime().date -le " mm/dd/yyyy " -and $_.resolutionState -ne 255} | resolve-alert main menu

Basic cmdlet, but wanted to add to the reference table.  The goal is to someday have the entire reference table complete with examples. install-managementpack " path " main menu