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.

m.[Name] AS [Computer Name]
, AD.AD_Site_Name0 AS [AD Site Name]
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: Logo

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

Facebook photo

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

Connecting to %s