:::: MENU ::::

Individual deployment summary for specific application (AppModel EnforcementState)

select distinct

aa.ApplicationName,

ae.AssignmentID,

aa.CollectionNameas'Target Collection',

ae.descriptas'Deployment Type Name',

s1.netbios_name0as'Computer Name',

ci2.LastComplianceMessageTime,

ae.AppEnforcementState,

casewhenae.AppEnforcementState= 1000 then'Success'

whenae.AppEnforcementState= 1001 then'Already Compliant'

whenae.AppEnforcementState= 1002 then'Simulate Success'

whenae.AppEnforcementState= 2000 then'In Progress'

whenae.AppEnforcementState= 2001 then'Waiting for Content'

whenae.AppEnforcementState= 2002 then'Installing'

whenae.AppEnforcementState= 2003 then'Restart to Continue'

whenae.AppEnforcementState= 2004 then'Waiting for maintenance window'

whenae.AppEnforcementState= 2005 then'Waiting for schedule'

whenae.AppEnforcementState= 2006 then'Downloading dependent content'

whenae.AppEnforcementState= 2007 then'Installing dependent content'

whenae.AppEnforcementState= 2008 then'Restart to complete'

whenae.AppEnforcementState= 2009 then'Content downloaded'

whenae.AppEnforcementState= 2010 then'Waiting for update'

whenae.AppEnforcementState= 2011 then'Waiting for user session reconnect'

whenae.AppEnforcementState= 2012 then'Waiting for user logoff'

whenae.AppEnforcementState= 2013 then'Waiting for user logon'

whenae.AppEnforcementState= 2014 then'Waiting to install'

whenae.AppEnforcementState= 2015 then'Waiting retry'

whenae.AppEnforcementState= 2016 then'Waiting for presentation mode'

whenae.AppEnforcementState= 2017 then'Waiting for Orchestration'

whenae.AppEnforcementState= 2018 then'Waiting for network'

whenae.AppEnforcementState= 2019 then'Pending App-V Virtual Environment'

whenae.AppEnforcementState= 2020 then'Updating App-V Virtual Environment'

whenae.AppEnforcementState= 3000 then'Requirements not met'

whenae.AppEnforcementState= 3001 then'Host platform not applicable'

whenae.AppEnforcementState= 4000 then'Unknown'

whenae.AppEnforcementState= 5000 then'Deployment failed'

whenae.AppEnforcementState= 5001 then'Evaluation failed'

whenae.AppEnforcementState= 5002 then'Deployment failed'

whenae.AppEnforcementState= 5003 then'Failed to locate content'

whenae.AppEnforcementState= 5004 then'Dependency installation failed'

whenae.AppEnforcementState= 5005 then'Failed to download dependent content'

whenae.AppEnforcementState= 5006 then'Conflicts with another application deployment'

whenae.AppEnforcementState= 5007 then'Waiting retry'

whenae.AppEnforcementState= 5008 then'Failed to uninstall superseded deployment type'

whenae.AppEnforcementState= 5009 then'Failed to download superseded deployment type'

whenae.AppEnforcementState= 5010 then'Failed to updating App-V Virtual Environment'

Endas'State Message'

fromv_R_System_Valids1

joinvAppDTDeploymentResultsPerClientaeonae.ResourceID=s1.ResourceID

joinv_CICurrentComplianceStatusci2onci2.CI_ID=ae.CI_IDAND

ci2.ResourceID=s1.ResourceID

joinv_ApplicationAssignmentaaonae.AssignmentID=aa.AssignmentID

whereae.AppEnforcementStateisnotnullandaa.ApplicationName='Adobe Reader XI 11.0.13'

orderbyLastComplianceMessageTimeDesc

So, what do you think ?