How to remove the Customer Experience Improvement Program (CEIP) task from Microsoft Dynamics GP


The CEIP task appears after you install Microsoft Dynamics GP. CEIP collects information about how a customer uses Microsoft products and about any problems that customers experience.

SQL Command:

USE DYNAMICS
set nocount on
declare @Userid char(15)
declare cCEIP cursor for 
        select A.USERID
        from SY01400 A left join SY01402 B on A.USERID = B.USERID and B.syDefaultType = 48
        where B.USERID is null or B.SYUSERDFSTR not like '1:%'
open cCEIP
while 1 = 1
begin
    fetch next from cCEIP into @Userid
    if @@FETCH_STATUS <> 0 begin
        close cCEIP
        deallocate cCEIP
        break
    end

    if exists (select syDefaultType from DYNAMICS.dbo.SY01402 where USERID = @Userid and syDefaultType = 48)
    begin
        print 'adjusting ' + @Userid
        update DYNAMICS.dbo.SY01402
        set SYUSERDFSTR = '1:'
        where USERID = @Userid and syDefaultType = 48
    end
    else begin
        print 'adding ' + @Userid
        insert DYNAMICS.dbo.SY01402 ( USERID, syDefaultType, SYUSERDFSTR )
        values ( @Userid, 48 , '1:' )
    end
end /* while */
set nocount off

No comments:

Post a Comment