To get a list of server names and what they are pending about i.e. AgentPendingActionType (this can be long depending on how many agent pending actions are in your environement)
get-agentpendingaction | sort-object AgentName | Select-object AgentName, AgentPendingActionType | format-table -auto
AgentName AgentPendingActionType
--------- ----------------------
AD01.My.Company.Com UpdateFailed
AD02.My.Company.Com RepairFailed
EXCH01.My.Company.Com PushInstallFailed
SMS01.My.Company.Com UpdateFailed
To get a list of servers whose status in AgentPendingActionType is ‘UpdateFailed’
get-agentpendingaction | where-object {$_.AgentPendingActionType -eq "UpdateFailed"} | sort-object AgentName | Select-object AgentName, AgentPendingActionType | format-table -auto
AgentName AgentPendingActionType
--------- ----------------------
AD01.My.Company.Com UpdateFailed
AD02.My.Company.Com UpdateFailed
EXCH01.My.Company.Com UpdateFailed
EXCH02.My.Company.Com UpdateFailed
To get a mini-report with the count and type of the agentpendingactiontype
get-agentpendingaction | group-object AgentPendingActionType | Sort -desc Count | Select-object Count, Name | Format-table -auto
Count Name
----- ----
90 UpdateFailed
1 PushInstallFailed
1 RepairFailed