SCOM Agent is not installed but still showing in Pending State in SCOM 2012 r2-Resolved

SCOM Agent is not installed but still showing in Pending State in SCOM 2012 r2-steps to resolve

• We recently had a issue where there is no SCOM agent on the server.But When we try to Install SCOM agent from Console its says there is already agent pending to be managed and doesn't allow to install.
• Then when we check the pending agent state it shows up there ,but if i go and check the server there is no SCOM agent.
• So we where puzzled how its coming in pending management. Then we reject in pending management it goes from there.But if i try to install agent again it comes in pending management.
• So its stuck in pending management,So this time i rejected it and its gone from there.
• Then i Ran the Command shell command

               GET-SCOMPendingManagement | where {$_.AgentName -eq "FQDNServername"

• And the server was showing pending in command shell but not in console.
• To fix it you need to login to Operations Manager database server and run the below store procedue on query window on the operations manager database

               p_AgentPendingActionDeletebyAgentName 'FQDNServername'