Showing posts with label Customer Experience Improvement Program (CEIP). Show all posts
Showing posts with label Customer Experience Improvement Program (CEIP). Show all posts

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