My Profile Photo

Ashley Poole

- Speaker -
- Senior Software Developer -
- Co-organiser of @ShropshireDevs -
- Site Reliability Engineering Advocate -

MSCRM Update User From Database

While updating the CRM database directly isn’t support sometimes it is the only way to work around the restrictions of the WUI. An example of when it is needed, is when there are duplicate users and CRM got confused.

<br />update SystemUserBase<br />set FullName = 'New FullName'<br />where FullName = 'Old FullName<br /> 
<br />--check queue name as well<br />select * from QueueBase<br />where name like '%name%'<br />

Posted on knowledge-base, devops with tags: sql-server

comments powered by Disqus