Tuesday, July 25, 2017

Outlook App enforcement report report

Outlook  App enforcement report report :-


select distinct  fn.machinename as 'ComputerName',vrs.user_name0 as 'UserID' ,fn.applicationname as 'DisplayName', fn.deploymenttypename as deploymenttypename,
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 'Microsoft Outlook 2016%' and
  fn.applicationname not like 'Microsoft Outlook 2016 XXXXXXXXX'
  and fn.appstate not like '3000' and fn.deploymenttypename like '%Install%'

  order by fn.machinename

No comments:

Post a Comment

site backup job manually

Start a scheduled SCCM 2012 site backup job manually You might want to start a scheduled SCCM 2012 site backup job manually. off co...