Skip to content

Instantly share code, notes, and snippets.

@danjpadgett
Last active February 21, 2018 14:19
Show Gist options
  • Save danjpadgett/93ee107e5016ea006d531585173627f0 to your computer and use it in GitHub Desktop.
Save danjpadgett/93ee107e5016ea006d531585173627f0 to your computer and use it in GitHub Desktop.
SCCM Client Push Request Queue
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'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment