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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
|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.