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.