SCCM SQL Query – Client Push Queue

I was looking into the built-in SSRS report titled ‘Client push installation status details’. This report shows the status of all client push attempts, including error codes.

I needed to extend this information for a client to include the workstations Active Directory Site name. I looked into SSRS and noticed it used the following stored procedure.

I looked into the stored procedure put together this query, adding information regarding the AD Site code.

	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'

view raw

CheckClientPushQueue.sql

hosted with ❤ by GitHub

The table seen below lists explanations for some of the possible exit codes.

Advertisement