SQL Scripts for Email Settings
The following script will change all the CRM Users' personal tracking email settings to whichever is chosen. The example below changes the email tracking settings to 'Email messages from CRM Leads, Contacts, and Accounts'
--rollback transaction
--commit transaction
--0 = ALL
--1 = REPLY ONLY
--2 = CRM LEADS, CONTACTS, AND ACCOUNTS
begin transaction
update UserSettingsBase
set IncomingEmailFilteringMethod = '2'
from UserSettingsBase usb
--where usb.SystemUserId = 'C073A1DE-F8BC-DF11-842C-005056961DD7'
|
The next script will inform you who is using the 'Allow use of e-mail credentials'.
select uu.IncomingEmailFilteringMethod,
uu.emailusername,uu.emailpassword, fu.fullname, uu.SystemUserId from UserSettingsBase uu
inner join FilteredSystemUser fu on fu.systemuserid = uu.systemuserid
order by uu.IncomingEmailFilteringMethod
|
<<Back