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
Subscribe to:
Post Comments (Atom)
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...
-
Application app enforcement deployment status with installation errors select distinct vrs.user_name0,fn.machinename,fn.applicationnam...
-
select SMS_R_System.Name, SMS_G_System_INSTALLED_SOFTWARE.ProductName, SMS_R_System.LastLogonUserName, SMS_R_System.LastLogonUserDomain, SMS...
-
select Name0, netbios_name0,user_name0,ProdID0 ,Displayname0, installdate0,publisher0,version0 from v_r_system inner join v_Add_Remove_Prog...
No comments:
Post a Comment