SCCM Client Push Request Queue

CheckClientPushQueue.sql

SELECT
          m.[Name] AS [Computer Name]
          ,m.[LatestProcessingAttempt]
         ,m.[LastErrorCode]
         ,m.[Description]
         , AD.AD_Site_Name0 AS [AD Site Name]
         ,m.[NumProcessAttempts]

FROM v_R_System AD
JOIN [CM_XXX].[dbo].[v_CP_Machine] m 
       ON AD.Name0 = m.Name
WHERE m.Description = 'Retry'