SCCM Query/Report with Application Installation return codes irrespective success or failure

Question

_{Monday, December 16, 2019 8:01 PM}

Hi,

I have created one application in SCCM and deployed to couple of machines. But I am able see only error (Return) code's on failures, not on success.

Is there any way to generate single report/query with all application installation return codes irrespective 'Success, In Progress, Error, Requirements Not met and Unknown' status?

Thanks in advance.

Er Reddy

All replies (3)

_{Monday, December 16, 2019 9:03 PM}

If you can get the result that you want for an error, then you can modify the report to give you the result for either an error or success. 

Garth Jones

Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

_{Wednesday, December 18, 2019 9:40 AM}

Hi,

Just checking in to see if there are any updates. Has this issue been solved?
Have you tried the solution provided by Garth(modify the report to give you the result for either an error or success)?
Please feel free to feedback and if the reply is helpful, please kindly click “Mark as answer”. It would make the reply to the top and easier to be found for other people who has the similar question.

Thank you!

Best regards,
Larry

Please remember to mark the replies as answers if they help. If you have feedback for TechNet Subscriber Support, contact [email protected].

_{Wednesday, December 18, 2019 10:19 AM}

Use the below SQL query (change the ae.Descript with your app name)

SELECT distinct       dbo.v_R_System.Netbios_Name0, ae.Descript, 
                         ae.ComplianceState, ae.AppEnforcementState,
case when ae.AppEnforcementState = 1000 then 'Success'
when ae.AppEnforcementState = 1001 then 'Already Compliant'
when ae.AppEnforcementState = 1002 then 'Simulate Success'
when ae.AppEnforcementState = 2000 then 'In Progress'
when ae.AppEnforcementState = 2001 then 'Waiting for Content'
when ae.AppEnforcementState = 2002 then 'Installing'
when ae.AppEnforcementState = 2003 then 'Restart to Continue'
when ae.AppEnforcementState = 2004 then 'Waiting for maintenance window'
when ae.AppEnforcementState = 2005 then 'Waiting for schedule'
when ae.AppEnforcementState = 2006 then 'Downloading dependent content'
when ae.AppEnforcementState = 2007 then 'Installing dependent content'
when ae.AppEnforcementState = 2008 then 'Restart to complete'
when ae.AppEnforcementState = 2009 then 'Content downloaded'
when ae.AppEnforcementState = 2010 then 'Waiting for update'
when ae.AppEnforcementState = 2011 then 'Waiting for user session reconnect'
when ae.AppEnforcementState = 2012 then 'Waiting for user logoff'
when ae.AppEnforcementState = 2013 then 'Waiting for user logon'
when ae.AppEnforcementState = 2014 then 'Waiting to install'
when ae.AppEnforcementState = 2015 then 'Waiting retry'
when ae.AppEnforcementState = 2016 then 'Waiting for presentation mode'
when ae.AppEnforcementState = 2017 then 'Waiting for Orchestration'
when ae.AppEnforcementState = 2018 then 'Waiting for network'
when ae.AppEnforcementState = 2019 then 'Pending App-V Virtual Environment'
when ae.AppEnforcementState = 2020 then 'Updating App-V Virtual Environment'
when ae.AppEnforcementState = 3000 then 'Requirements not met'
when ae.AppEnforcementState = 3001 then 'Host platform not applicable'
when ae.AppEnforcementState = 4000 then 'Unknown'
when ae.AppEnforcementState = 5000 then 'Deployment failed'
when ae.AppEnforcementState = 5001 then 'Evaluation failed'
when ae.AppEnforcementState = 5002 then 'Deployment failed'
when ae.AppEnforcementState = 5003 then 'Failed to locate content'
when ae.AppEnforcementState = 5004 then 'Dependency installation failed'
when ae.AppEnforcementState = 5005 then 'Failed to download dependent content'
when ae.AppEnforcementState = 5006 then 'Conflicts with another application deployment'
when ae.AppEnforcementState = 5007 then 'Waiting retry'
when ae.AppEnforcementState = 5008 then 'Failed to uninstall superseded deployment type'
when ae.AppEnforcementState = 5009 then 'Failed to download superseded deployment type'
when ae.AppEnforcementState = 5010 then 'Failed to updating App-V Virtual Environment'
when ae.AppEnforcementState is NULL then 'No Message Received'
end as 'state message' 
FROM            dbo.v_R_System INNER JOIN
                         dbo.vAppDTDeploymentResultsPerClient ae ON dbo.v_R_System.ResourceID = ae.ResourceID
where ae.Descript like '%Office%'