Updating fields in sql
App Enforcement State= 2011 then'Waiting for user session reconnect' whenae. Version0 AS [Version], dbo.v_Full Collection Membership. Collection ID FROM dbo.v_Add_Remove_Programs AS a INNER JOIN dbo.v_R_System AS c ON a. Resource ID INNER JOIN dbo.v_Full Collection Membership ON c. App Enforcement State= 2012 then'Waiting for user logoff' whenae. Modified On Order By [Sorted: Boundary Values] SELECT DISTINCT c. App Enforcement State= 3000 then'Requirements not met' whenae. App Enforcement State= 3001 then'Host platform not applicable' whenae. App Enforcement State= 5000 then'Deployment failed' whenae. IP_Subnets0 like ‘172.1[6-9].%’ or v_RA_System_IPSubnets. IP_Subnets0 like ‘172.2[0-9].%’ or v_RA_System_IPSubnets. IP_Subnets0 like ‘172.3[0-1].%’) or (v SMS_Boundary. App Enforcement State= 2007 then'Installing dependent content' whenae. App Enforcement State= 2008 then'Restart to complete' whenae. User_Domain0 AS [Domain Name], dbo.v_GS_SYSTEM_ENCLOSURE. Manufacturer0 AS Manufacturer, dbo.v_GS_COMPUTER_SYSTEM. Source Collection ID ‘)’ when cdepend.relationshiptype = 2 then ‘Include ‘ ‘ (‘ cdepend. Serial Number0 AS [Serial Number], dbo.v_GS_SYSTEM. Name as ‘Collection Dependency Name’, Case When cdepend.relationshiptype = 1 then ‘Limited To ‘ ‘ (‘ cdepend. Collection ID = ‘XXX0077A’ select * from fn_List Latest Application CIs(1033) select Date Created, Date Last Modified, Display Name, Manufacturer, Software Version, Created By, Last Modified By from fn_List Latest Application CIs(1033) GROUP BY Date Created, Date Last Modified, Display Name, Manufacturer, Software Version, Created By, Last Modified By ORDER BY Date Created DESC For deployment types ::: fn_List Deployment Type CIs(1033) SELECT DISTINCT dbo.v_R_System.
App Enforcement State= 1002 then'Simulate Success' whenae.
App Enforcement State= 2002 then'Installing' whenae. App Enforcement State= 2003 then'Restart to Continue' whenae. Is Deployed=1 )then ‘Required_ITICSDeploy’ WHEN (UCS.
App Enforcement State= 2001 then'Waiting for Content' whenae.
App Enforcement State= 2013 then'Waiting for user logon' whenae.
App Enforcement State= 2014 then'Waiting to install' whenae.
Search for updating fields in sql:
App Enforcement State= 5005 then'Failed to download dependent content' whenae.