CM2207_KB15152495_AppCheck.sql

CM2207_KB15152495_AppCheck.sql

--
-- Applicability check
--
--
--  APPLICABILITY_SUCCESS       = 0x00050002,       // 327682
--  APPLICABILITY_HIDE          = 0x0005FFFD,       // 393213
--  APPLICABILITY_NA            = 0x0005FFFE,       // 393214

SET NOCOUNT ON

    DECLARE @Applicable INT

    -- check whether it is 2207 TAP Build
    IF EXISTS ( (select * from CM_UpdatePackages where PackageGuid in (
                '0523A730-A24B-49EA-931E-96C88993E92E',    -- E3
                '14FEC01C-73C0-4060-A9BD-3AA5E9488A8C',    -- E5
                'E5E7C6FE-3AFF-4E59-8360-E23549AAE16E',    -- E6
                'E992620F-54C3-446A-9EC8-FFB12BA98C2F'     -- E7
        ) and state= 196612))
    BEGIN 

	-- check whether has TAP Rollup installed
		IF EXISTS ( (select * from CM_UpdatePackages where PackageGuid in (          
                '02DFEA46-318E-4005-BA56-BFCFA3BC41FA'    -- TAP Rollup
        ) and state= 196612))
		BEGIN       

			PRINT 'This is a 2207 TAP build and have installed TAP Rolup.'
			SET @Applicable = 327682

		END  
		          
		ELSE
		BEGIN

		    PRINT 'This is a 2207 TAP build but did not install TAP Rollup.'
		    SET @Applicable = 393213
			
		END
    END

    ELSE
    BEGIN    

        PRINT 'This is a 2207 Fast Ring or SR build.'
        SET @Applicable = 327682

    END

    SELECT @Applicable