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
Subscribe to:
Posts (Atom)