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'

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s