SQL query for Application app enforcement deployment status in SCCM 2012

Application app enforcement deployment status with installation errors

select  distinct vrs.user_name0,fn.machinename,fn.applicationname,fn.deploymenttypename,fn.Enforcementtime,errorcode,

case when fn.appstate='1000' then 'Success'

when fn.appstate='1001' then 'Already Compliant'

when fn.appstate='1002' then 'Simulate Success'

when fn.appstate='2000' then 'In progress'

when fn.appstate='2001' then 'Waiting for content'

when fn.appstate='2002' then 'Installing'

when fn.appstate='2003' then 'Restart to continue'

when fn.appstate='2004' then 'Waiting for maintenance window'

when fn.appstate='2005' then 'Waiting for schedule'

when fn.appstate='2006' then 'Downloading dependent content'

when fn.appstate='2007' then 'Installing dependent content'

when fn.appstate='2008' then 'Restart to complete'

when fn.appstate='2009' then 'Content downloaded'

when fn.appstate='2010' then 'Waiting for update'

when fn.appstate='2011' then 'Waiting for user session reconnect'

when fn.appstate='2012' then 'Waiting for user logoff'

when fn.appstate='2013' then 'Waiting for user logon'

when fn.appstate='2014' then 'Waiting To Install'

when fn.appstate='2015' then 'Waiting Retry'

when fn.appstate='2016' then 'Waiting For Presentation Mode'

when fn.appstate='2017' then 'Waiting For Orchestration'

when fn.appstate='2018' then 'Waiting For Network'

when fn.appstate='2019' then 'Pending App-V Virtual Environment Update'

when fn.appstate='2020' then 'Updating App-V Virtual Environment'

when fn.appstate='3000' then 'Requirements not met'

when fn.appstate='3001' then 'Host Platform Not Applicable'

when fn.appstate='4000' then 'Unknown'

when fn.appstate='5000' then 'Deployment failed'

when fn.appstate='5001' then 'Evaluation failed'

when fn.appstate='5002' then 'Deployment failed'

when fn.appstate='5003' then 'Failed to locate content'

when fn.appstate='5004' then 'Dependency installation failed'

when fn.appstate='5005' then 'Failed to download dependent content'

when fn.appstate='5006' then 'Conflicts with another application deployment'

when fn.appstate='5007' then 'Waiting Retry'

when fn.appstate='5008' then 'Failed to uninstall superseded deployment type'

when fn.appstate='5009' then 'Failed to download superseded deployment type'

when fn.appstate='5010' then 'Failed to updating App-V Virtual Environment'

end as 'Laststatusmessage'

 from fn_AppDTClientSummarizedState('') fn join v_r_system vrs on vrs.name0=fn.machinename

  where fn.applicationname  like '%OFFICE02013ENGC2A4%' and fn.appstate not like '3000' and fn.deploymenttypename in ('OFFICE02013ENGC2A4-Win7','OFFICE02013ENGC2A4-Win8')