SCOM Agent Pending Actions can get out of sync between the Console, and the database

Problem
==========
Agent Pending Actions can get out of sync between the Console, and the database

Cause

========

Orphaned client record in 'agentpendingaction' table of OperationsManagerDB

Action
=============

get-scompendingmanagement

get-scompendingmanagement | where{$_.Agentname -eq "agentname"}|  

get-scompendingmanagement | where{$_.Agentname -eq "agentname"}| Approve-SCOMpendingManagement

agentname 改成您的Agent名稱

Solution
=========

NOTE Before executing any query against the Operations Manager database be sure that a complete and current backup exists. 

exec p_AgentPendingActionDeleteByAgentName 'agentname.domain.com'